SQLServerWiki

“The Only Thing That Is Constant Is Change”

rebuilding indexes and updating statistics for all the tables in a database.

Posted by database-wiki on March 21, 2011

use <Database Name>

go

sp_MSforeachtable “DBCC DBREINDEX (‘?’)”
— After this one is completed, start the update statistics on the databases using the below command,

Use <Database Name>

go

sp_MSforeachtable “UPDATE STATISTICS ? WITH Fullscan”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: