-
Why Every Byte Matters for SQL Server Pages
Think of a SQL Server data page as a Delta carry-on suitcase. It is always the same size, 8 kilobytes. When people talk about making SQL Server fast, they usually
-
What Causes Locking and Blocking and When to Take Action
It’s common to see a lock and immediately assume it’s the problem. Many people believe that any lock is a bad thing. I’ve had to explain this many times, so
