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.
I Let AI Recommend SQL Server Indexes Across a Week of Queries
I let AI recommend SQL Server indexes across a week of queries, measured every number before and after, and the result was not the one I expected to write about.
Eleven SQL Server Interview Questions That Look Far Too Easy
These eleven SQL Server interview questions look far too easy, and every one of them has stopped somebody senior.
Nine Unusual Ways My Clients Use AI With SQL Server
Everyone writes about AI generating queries. Here are nine unusual ways my clients use AI with SQL Server, and I helped build every one.
Hire AI and Not Me: Human Can Make Mistakes
Let me tell you something that took me a long time to say out loud. Human Can Make Mistakes Not AI. (Well, line inspired from famous GenAI tool).