Browse by Tags

• best practice
• dbcc
• defrag
• log
• performance
• security
• showcontig
• sql server
• table
• tempdb
• update statistics

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

Update statistics causing negative performance
17 August 07 06:11 PM | SQL Master | 2 Comments   

Recently we have seen a negative performance for a query that is running against a 500GB size of database, where AUTO UPDATE STATISTICS is enabled and we perform weekly reindexing on this database. In addition to this I perform intermittent update statistics Read More...

Filed under: performance, sql server, fragmentation, update statistics, index, tempdb, log, best practice