Query for Rebuild all Indexes of Database at Single Click

Query for REBUILD all indexes in Database : -
 
 DECLARE @TableName VARCHAR(255)
 DECLARE @sql NVARCHAR(500)
 DECLARE @fillfactor INT
 SET @fillfactor = 80
 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 (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')' print @sql EXEC (@sql) FETCH NEXT FROM TableCursor INTO @TableName END CLOSE TableCursor DEALLOCATE TableCursor GO

Above query return all rebuild indexes query after rebuild operation done. I used cursor for rebuild indexes table by table.
Ebook Download
View all
Learn
View all