Data types that waste space include oversized integers, blanket nvarchar(max), and unnecessary datetime2 precision; measure before changing.
Index Optimization Checklist: A Printable One-Page Guide
The twelve things I ask a junior DBA to check before I touch a slow query, with three quick proofs you can run yourself.
What Is a Heap in SQL Server?
A heap in SQL Server is a table with no clustered index. Forwarded records pushed one count from 11,113 reads to 199,844, and a single REBUILD put it back. When a heap is fine and when it is not.
SQL SERVER – Good, Better and Best Programming Techniques
My notes for a programmers meeting on Good, Better and Best Programming Techniques in SQL Server, plus a funny bug ticket about a client who got no email.
SQL SERVER – Difference Between Unique Index vs Unique Constraint
Unique Index vs Unique Constraint: is there a difference? No. A unique constraint creates a unique index, and performance is the same. Syntax for both.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table
A query to list every identity column with its seed, increment and current value, plus what those numbers mean and how to reseed a table safely.
SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index
Clustered index and non-clustered index compared: how many you can have, how each stores data, and where the SQL Server 2005 included column index fits.