Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag update statistics Rss

Search for any content tagged update statistics

   Items 1 to 5 of 5   
 

Improved Support for Parallel Statistics Rebuilds

Jonathan Kehayias takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.  Read more...
By Additional Articles 2016/06/20 | Source: SQLPerformance.com | Category: trace flag 7471
Rating: (not yet rated)  Rate this |   Briefcase | 2,792 reads

A Spectacular Case of 100% CPU Caused by Online Reindexing

An investigation of a serious performance issue during online re-indexing on a production server leads us to interesting discoveries and solutions.  Read more...
By Viktor Gorodnichenko 2014/12/11 | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 7,095 reads

SQL Server's Auto Update Statistics Async Option

I have been trying to tune my SQL Server and I noticed a few database settings for statistics. I also read the previous tip on automatic statistics updates. Could you please describe the Auto Create Statistics Async option? How is this configured and when should I use it and when should I avoid using it?  Read more...
By Additional Articles 2013/03/26 | Source: MSSQLTips.com | Category: async
Rating: (not yet rated)  Rate this |   Briefcase | 3,999 reads

Update statistics in parallel

This articles shows a technique that generates and launches an SSIS package to update statistics in parallel.  Read more...
Rating: |  Discuss |   Briefcase | 5,104 reads

Turbocharge Your Database Maintenance With Service Broker: Part 1

Are your maintenance windows too wide? Find out how to shrink them with Service Broker.  Read more...
By Marios Philippopoulos 2012/07/09 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 7,688 reads
   Items 1 to 5 of 5