- Reorganize and Rebuild Indexes (MSDN)
- Indexes on Computed Columns
- A Spectacular Case of 100% CPU Caused by Online Reindexing
- Understanding Full-Text Indexing in SQL Server
- SQL Server Query Performance After Index Maintenance for Reorganization vs Rebuild Operations
- An Indexed View Bug with Scalar Aggregates
- Query Tuning Fundamentals: Density, Predicates, Selectivity, and Cardinality
- Identifying and Solving Index Scan Problems
- Foreign Key Indexes and Binding
- New indexes, hypothetically
Filtered Indexes
- Why isn’t my filtered index being used?
- “OR” and “IN” with SQL Server’s Filtered Indexes
- Filtered Indexes: Just Add Includes
