Rebuild all index

USE <DatabaseName>
GO
DECLARE @TableName VARCHAR(255) 
DECLARE @sql NVARCHAR(500)
DECLARE TableCursor
CURSOR
FOR
SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName
FROM sys.tables OPEN TableCursor FETCH NEXT
FROM TableCursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN
SET @sql = 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD 
WITH (ONLINE = ON)' EXEC (@sql) FETCH NEXT
FROM TableCursor 
INTO @TableName END CLOSE TableCursor DEALLOCATE TableCursor
GO

This site uses Akismet to reduce spam. Learn how your comment data is processed.