Home Forums SQL Server 2005 Backups INDEX REBULID RE: INDEX REBULID
Bhaskar.Shetty
Hall of Fame
Points: 3054
More actions
May 23, 2013 at 2:46 am
#1617751
ReIndex all the Indexes from the Databases.
EXEC sp_msforeachtable @COMMAND1="PRINT '?' DBCC DBREINDEX('?','',80)"
GO
Update all Statistics from the Database.
EXEC SP_UPDATESTATS