Browse by Tags

• fragmentation
• performance
• table

How to detect a table fragmentation?
29 May 07 06:02 PM | SQL Master | 2 Comments   

In SQL 2000 version days you could take help of DBCC SHOWCONTIG statement, but this is deprecated in SQL Server 2005, so how to go about it. You can take help DMVs & DMFs in this case, DMV - Dynamic Management View and DMF - Dynamic Management Function, Read More...

Filed under: performance, troubleshoot, table, dbcc, fragmentation