When enabling clustered and non-clustered indexes, order matters: enabling the clustered index does not enable the others, but rebuilding all indexes does.
SQL SERVER – Get Information of Index of Tables and Indexed Columns
sp_helpindex is a handy stored procedure that shows every index on a table, its description and the indexed columns. One line of T-SQL does it.
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.
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 – Disable All Triggers on a Database – Disable All Triggers on All Servers
How to disable all triggers on a database and on the server, which kind of trigger each command touches, and how to turn them back on safely.
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.
SQL SERVER – Set Server Level FILLFACTOR Using T-SQL Script
A short T-SQL script to set server level FILLFACTOR, plus the Books Online definition of FILLFACTOR and what its values from 0 to 100 mean.