Skip to content

Instantly share code, notes, and snippets.

@jbubriski
Created February 22, 2018 17:28
Show Gist options
  • Save jbubriski/3eb38451d4835c8d761303f7aa7f5249 to your computer and use it in GitHub Desktop.
Save jbubriski/3eb38451d4835c8d761303f7aa7f5249 to your computer and use it in GitHub Desktop.
This will rebuild all the indexes in your DB.
DECLARE @TableName varchar(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
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment