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

Content with tag update statistics Rss

   Items 1 to 4 of 4   
 

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,448 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

Update Statistics

By FOR SQLSERVER 2011/07/06 | Category: update statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 2,501 reads
   Items 1 to 4 of 4   
 
Tags
async (1)    
database maintenance (1)    
dtsx generate (1)    
integration services (ssis) (1)    
internal activation (1)    
multi-threading (1)    
parallel (1)    
parallel execution (1)    
service broker (1)    
sp_updatestats (1)