Karl’s Blog
msgbartop
msgbarbottom

10 Apr 12 How to reindex every table with SQL Server

A useful script I’ve used to reindex every table in an SQL Server database.

EXEC sp_MSforeachtable 'DBCC DBREINDEX (''?'', '' '', 80)'
GO
EXEC sp_updatestats
GO