Programming

Categories

  • No categories

SEARCH

I’m Attending

CodeMash

Reindex All Tables in Database (SQL Server)

Posted in: Programming by Steve on December 7, 2011

Another thing I do a lot and always forget about:

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO