Quick way to Reindex all tables on SQL Server Database

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

Leave a Reply

Your email address will not be published. Required fields are marked *

*