Rebuilding all Indexes

USE [DATABASE_NAME] GO DECLARE @TableName varchar(255) DECLARE TableCursor CURSOR FAST_FORWARD FOR SELECT table_name FROM information_schema.tables WITH (NOLOCK) WHERE table_type = 'base table' OPEN TableCursor FETCH NEXT FROM TableCursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN DBCC DBREINDEX(@TableName,' ',90) FETCH NEXT FROM TableCursor INTO @TableName END CLOSE TableCursor DEALLOCATE TableCursor GO