SQL [Internal] Defragmentation

[FREE] SQL Server Maintenance Solution

Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://technet.microsoft.com/en-us/library/cc966523.aspx

How to check defragmentation level

SQL Server Index Fragmentation and Its Resolution
www.sql-server-performance.com/articles/per/index_fragmentation_p1.aspx
---

In SQL Server, there are several ways to defrag internal fragmentation. One of these methods is to use the DBCC REINDEX command to rebuild the clustered and non-clustered indexes. Once indexes are rebuilt, data pages are now logically contiguous, and disk I/O is minimized.

Defrag Your SQL Server Database or Go to Pieces
http://findarticles.com/p/articles/mi_pwwi/is_200608/ai_n16686663/