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