Index Rebuild drops and recreates the index, while Index Reorganize reorders the leaf nodes. Rebuild above 40% fragmentation, reorganize between 10% and 40%.
SQL SERVER – Enabling Clustered and Non-Clustered Indexes – Interesting Fact
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.