Browse by Tags

• best practice
• index
• performance
• sql server
• tempdb
• update statistics

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