Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

Reindex and rebuild statistics for entire database (See related posts)

// Reindex and rebuild statistics for each table in the database

EXEC sp_MSforeachtable "dbcc dbreindex('?')"
EXEC sp_MSforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN'
to sql mssql by taurin on Fri Mar 07 22:46:24 +0000 2008

You need to create an account or log in to post comments to this site.


Related Posts