Read a database benchmark by checking workload rules, hardware, durability, latency, pricing scope, and whether the test can be repeated.
Spreading Rows Into Hash Buckets With CHECKSUM and Modulo
Equal row counts do not mean equal work, and patterned keys can pile into one bucket. Here is how to test your buckets before adding workers.
Asking a SQL Question That Gets Answered: The Reproducible Script
Write a reproducible script with minimal tables, synthetic rows, the failing query, expected results, and the exact SQL Server version.
Finding Which Network Protocol Each Session Uses
Before you switch off a protocol, find out who still uses it. Two short queries show how each session connected, and why the address is not a person.
Converting float to Text Without Losing Digits
The default float to text conversion keeps about six digits. Here is the one style that gives your float back exactly, and the traps around it.
Spotting Definition Drift With HASHBYTES on Module Code
Did someone change a production procedure and forget to tell you? Hash the module text, compare it with a baseline, and let SQL Server point at the culprit.







