How to Identify and Fix SQL Server Index Fragmentation

Although SQL Server automatically maintains indexes after any INSERT, UPDATE, DELETE, or MERGE operation, some index maintenance activities on your databases may still be required, mostly due to index fragmentation. Fragmentation happens when the logical order of pages in an index does not match the physical order in the data file. Because fragmentation can affect […]

Read More

Rebuilding a SQL Server Index

Fragmented index data causes the SQL Server Database Engine to perform additional data reads, and decreases performance. To fix this problem, you must rebuild fragmented indexes. Learn more.

Read More

Obtaining SQL Server Index Fragmentation Information

To get information concerning internal index fragmentation in SQL Server, use the DMV sys.dm_db_index_physical_stats. Learn how.

Read More