Use CHECKSUM_AGG for a quick table-copy signal, then compare canonical HASHBYTES values and key ranges to locate real data differences.
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.
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.
GREATEST, LEAST and Other Small Helpers
GREATEST, LEAST, and recent T-SQL helpers replace bulky CASE patterns while preserving explicit rules for NULL and data types.
Date Boundaries With DATETRUNC and EOMONTH in SQL Server 2022
Use DATETRUNC and EOMONTH for month, quarter, and week boundaries in SQL Server 2022, including index-friendly half-open filters.
SQL SERVER – Solution to Puzzle – REPLICATE over 8000 Characters
Here is the answer to my puzzle on REPLICATE over 8000 characters, with a quick recap of the script and why the lengths come out the way they do.