SQL Server limits, done the way a record book does them. Not what the documentation says, but what happened when I tried one more. Eleven records, each attempted on SQL Server 2025 build 17.0.4085.5, each with the exact error text at the edge. One documented figure turned out to be wrong on this…
The Nightly Index Rebuild Job, 1998 to 2026: An Obituary
The nightly index rebuild job has died after a long illness. It was born in 1998 to a hard disk that could not seek. It never believed the disk had been replaced. It is survived by page density, which did most of its work all along.
Slow Queries: A Field Guide to Eight Species
Slow queries, identified the way a field guide identifies birds: by silhouette, habitat, call, and the species they’re confused with. All eight were raised in the lab on SQL Server 2025. The reads and the wait types are what each one produced.
When a GUID Clustered Primary Key Gets Expensive
A GUID primary key can be useful. Learn when a GUID clustered primary key gets expensive, from page splits to index size, and when a bigint key can help.
NOLOCK Double Counting: One Employee, Two Lunches
NOLOCK double counting is how three people in a lunch line turn into four lunches. Nothing was inserted. One row moved ahead of the scan and got read twice. I tested it on SQL Server 2025 and share a query that catches it on your own table.
Your Index Rebuild Maintenance Plan Is Rebuilding Indexes Nobody Uses
Your index rebuild maintenance plan takes four hours every Sunday, fills the log and delays the backup. It may be buying you far less than everybody assumes.
NOLOCK: Why It Counts Some Rows Twice and Misses Others
Everybody knows NOLOCK can show uncommitted data. Far fewer know why it counts some rows twice and misses others, with nothing rolled back. Let me show you.