Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag update statistics Rss

Search for any content tagged update statistics

   Items 1 to 3 of 3   
 

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,446 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 | 4,820 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,181 reads
   Items 1 to 3 of 3