Rebuild svih indexa u bazi

USE ImeBaze

DECLARE @TableName nvarchar(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  @TableName + '.....'
DBCC DBREINDEX(@TableName,' ',0) -- FillFactor=0

FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

PRINT 'Finished!'