Use CHECKSUM_AGG for a quick table-copy signal, then compare canonical HASHBYTES values and key ranges to locate real data differences.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Sample Databases for Practicing Performance Tuning
Use sample databases for practicing performance tuning by checking data volume and skew, then enlarging the right tables carefully.
LEN vs DATALENGTH: Trailing Spaces, Unicode Bytes and NULL
Compare LEN vs DATALENGTH for trailing spaces, Unicode, UTF-8, NULL, and MAX values before safely resizing SQL Server string columns.
SQL SERVER – Storing 64-bit Unsigned Integer Value in Database
A reader moving from MySQL to SQL Server had a 64-bit unsigned integer column and no matching data type. Here is how I suggest storing that value.
GETDATE vs SYSDATETIME: Precision of the Current Time
Compare SYSDATETIME with GETDATE and UTC time functions, understand datetime rounding, and choose a clear timestamp type and clock contract.
Bit Functions in SQL Server 2022: BIT_COUNT, GET_BIT and LEFT_SHIFT
Use BIT_COUNT and SQL Server 2022 bit functions to read, set, count, and shift flags, while choosing clear storage for ordinary settings.
What to Look For in a SQL Client Tool
Choose a SQL client tool by testing result handling, execution plans, transactions, and connection identity before trusting it with real work.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.