Indexes

Designing Indexes

• SQL 2005 Index Performance Order 
• SQL 2008+ Filtered Indexes

Finding Indexes

• Listing Tables, Columns & Indexes
• Tables without Indexes
• Finding Duplicate Indexes

Index Usage

Index Usage can be seen from system table sys.dm_db_index_usage_stats which is explained in detail here.

• TSQL to show index usage in current db
• Using Missing Indexes DMVs to generate index suggestions
  

Managing Indexes

• *** Index Fragmentation Status *** (Includes Partitioned indexes)
• Fragmentation 101  
• Finding Fragmentation of an Index
• TSQL to determine Index Fragmentation
• Reorganize / Rebuild a single index
• Index Size Script
• Partitioned Index Size Script
• Database level options for Updating Table Statistics
• Disabling an Index
• Rebuilding an Index
• Moving tables / indexes across filegroups
• Forcing Index Choice

XML Indexes

• XML Indexes
• Usp_DropXmlIndexes