SQL Server Update Statistics with FULL SCAN

Leave a comment (0) Go to comments

 

Sometimes you just need a quick method to update all statistics of every table. The script below will apply a FULL SCAN , so I wouldn’t recommend that you use this as regular maintenance task .

Today, this was being asked by one of the DBA during the training hours.  I thought let me post a write up on this

 

exec sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN'

This script will update stats of all tables with FULL SCAN option.

EOF - SQL Server Update Statistics with FULL SCAN, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.