m-u
8/28/2015 - 9:59 AM
Rebuild indexes sql server
Rebuild indexes sql server
-- Re Index
EXEC sp_MSforeachtable "dbcc dbreindex('?', '')"
-- Update Stats
--EXEC sp_updatestats
-- or
EXEC sp_MSforeachtable "UPDATE STATISTICS ? WITH FULLSCAN"Rebuild indexes sql server
-- Re Index
EXEC sp_MSforeachtable "dbcc dbreindex('?', '')"
-- Update Stats
--EXEC sp_updatestats
-- or
EXEC sp_MSforeachtable "UPDATE STATISTICS ? WITH FULLSCAN"