How to Detect Table Fragmentation in SQL Server 2000 and 2005

(Satya Jayanty) How do you know when a table is fragmented? –Poor query performance over time. –More disk activity. –Poor cache utilization. –Verify the I/O of a query. –Verify scan density in SQL 2000 using DBCC SHOWCONTIG and in SQL 2005 using the dynamic management view sys.dm_db_

Read More - Register for Free Membership