How to rebuild index and update statistics for all the tables in database.
Posted by Karthick P.K on September 26, 2010
EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN' -- {can be run anytime}
Exec sp_MSforeachtable "dbcc dbreindex('?')" --- {Always run this on a off-peak hour on any SQL Server instance}
Thanks
Karthick
Like this:
Like Loading...
This entry was posted on September 26, 2010 at 1:57 PM and is filed under Optimizer, Performance, SQL General, SQL Query.
Tagged: Rebuild indexfor all tables, reindex all tables in database, Script to rebuild index for all tables, SQL General, SQL Query. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
