– reindex all indexes
DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = ‘base table’
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT ‘Reindexing [' + @TableName + ']‘
DBCC DBREINDEX(@TableName,’ ‘)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
– ===========================================================================–
DECLARE @Comm varchar(8000)
DECLARE Cur CURSOR FAST_FORWARD FOR
SELECT ‘UPDATE STATISTICS [' + o.name + '] WITH FULLSCAN’
FROM sysobjects o
WHERE ( OBJECTPROPERTY(o.id, N’IsUserTable’) = 1
OR OBJECTPROPERTY(o.id, N’IsUserView’) = 1 )
AND OBJECTPROPERTY(o.id, N’IsMSShipped’) = 0
ORDER BY o.name
OPEN Cur
FETCH NEXT FROM Cur INTO @Comm
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @Comm
EXEC (@Comm)
FETCH NEXT FROM Cur INTO @Comm
END
CLOSE Cur
DEALLOCATE Cur
