How to Detect Table Fragmentation in SQL Server 2000 and 2005

Table fragmentation can occur when modifying data with INSERT, UPDATE, or DELETE statements, which over time cause gaps in each page. If a query search is based on a table scan or partial table scan, then it will create overhead for the SQL Server process with additional page reads, leading to high CPU activity and unresponsiveness. By Satya Jayanty.

Read More...

---