Fragmentation and Index Maintenance

Beneficial SQL Server Fragmentation and Index Maintenance tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.

Title Author Date
Rebuilding SQL Server indexes using the ONLINE option Ben Snaidero2026-05-29
Rebuild all SQL Server Indexes for all Tables in all Databases Greg Robidoux2025-05-28
Efficiently Rebuild SQL Server Clustered Indexes with DROP_EXISTING MSSQL Tips2025-04-20
SQL Server Index Fragmentation Considerations with Modern Hardware Jared Westover2023-10-10
SQL Server Index Maintenance Checklist Greg Robidoux2022-05-26
SQL Server Index and Statistics Report Tim Ford2020-08-13
SQL Server Rebuilds and Reorganize Script for Index Fragmentation Artemakis Artemiou2016-09-28
SQL Server Index Fragmentation Overview Brady Upton2016-06-22
Using SQL Server Managed Lock Priority for Online Index Rebuilds Burt King2015-11-13
Solving SQL Server Database Physical File Fragmentation Daniel Farina2013-08-13
Automated and Formatted Index Maintenance Reports for SQL Server Douglas P. Castilho2013-06-03
Fixing Index Fragmentation in SQL Server 2005 and SQL Server 2008 Arshad Ali2009-07-10
Index Fragmentation Report in SQL Server Arshad Ali2009-03-16
Auto Grow, Auto Shrink and Physical File Fragmentation in SQL Server MSSQL Tips2008-04-21
Custom SQL Server Index Defrag and Rebuild Procedures Chad Boyd2008-03-09
SQL Server Fragmentation Hands On Experience (Part 9 of 9) Chad Boyd2008-03-01
SQL Server Fragmentation How to address it (Part 8 of 9) Chad Boyd2008-02-23
SQL Server Fragmentation How to detect it (Part 6 of 9) Chad Boyd2008-02-22
SQL Server Fragmentation Custom Detection Procedure, Page Linkage Part 7 Chad Boyd2008-02-22
SQL Server Fragmentation What it impacts and what it does not Part 5 of 9 Chad Boyd2008-02-17
SQL Server Fragmentation How to avoid it (Part 4 of 9) Chad Boyd2008-02-13
Managing SQL Server Database Fragmentation Greg Robidoux2007-01-25
Selectively rebuild indexes with SQL Server maintenance plans Greg Robidoux2006-12-08