A collection of articles covering SQL index analysis, defragmentation and rebuild index topics
Index defragmentation
- How to automate and schedule SQL Server index defragmentation
- How to automate SQL Server defragmentation using policies
- How to configure fill factor for SQL Server indexes
- How to customize policies for automatically defragmenting SQL Server indexes
- How to detect a high level of SQL Server database index fragmentation and fix it automatically
- How to monitor the status of index defragmentation jobs
- Online vs offline SQL Server index rebuild in SQL Server
- SQL Index Fragmentation and Maintenance
- SQL index fragmentation reports
- Why, when and how to rebuild and reorganize SQL Server indexes
