Browse by Tags

• dbcc
• defrag
• index
• indexes
• performance
• showcontig
• sql server
• table

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value
24 August 07 04:24 AM | SQL Master | 2 Comments   

This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level scan performed. Read More...

Filed under: performance, sql server, security, table, dbcc, fragmentation, index, defrag, showcontig

Index fragmentation and DBCC SHOWCONTIG in SQL Server 2005!
03 July 07 02:55 AM | SQL Master | 0 Comments   

In SQL Server 2005 Dynamic Management Views (DMV) & DM Functions (DMF) allows you the look inside the server to return the required information. It will also helps you to monitor the server instance health and performance to diagnose the problem. Read More...

Filed under: performance, security, indexes, dbcc, fragmentation