security, performance, fragmentation - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Browse by Tags

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value Published 24 August 7 6:24 AM | SSQA.net: 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...

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