When enabling clustered and non-clustered indexes, order matters: enabling the clustered index does not enable the others, but rebuilding all indexes does.
Stress Testing a Query Before Release
Stress testing a query before release reveals concurrency and parameter risks; learn to design realistic SQL Server tests and compare useful metrics.
Keyset Pagination: Next and Previous Pages Without OFFSET
Build keyset pagination with a matching index, unique tie breaker, next and previous queries, and a fair deep-page comparison with OFFSET.
Explaining a Query Plan to a Developer
Explaining a query plan starts with the costly work, checks estimates against actual rows, and turns findings into a clear code decision.
Finding Unused Indexes
Finding unused indexes requires a measured window, SQL Server usage counters, and a safe removal test before an index earns a drop decision.
SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS
Forced parameterization can cut query compilations for busy databases. I explain FORCED vs SIMPLE parameterization and how to set each with T-SQL and SSMS.
SQL SERVER – 2005 – Limitation of Online Index Rebuld Operation
What is an online index rebuild, and which indexes can not be rebuilt online? A smart interview candidate and I found four, and Books Online lists all six.







