My 20 SQL Commandments for SQL Server, rewritten from an Oracle article: know your data, test with realistic data, write identical statements, and more tips.
SQL SERVER – ReIndexing Database Tables and Statistics with Targeted Maintenance
ReIndexing Database tables starts with a measured maintenance need. I check the workload before choosing an index operation.



