Rebuild All Indexes For All Tables And One Databases

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

ORDER BY NAME

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