Skip to content

Instantly share code, notes, and snippets.

@thorsman99

thorsman99/rebuildallindexes.sql

Created October 1, 2017 03:10
Show Gist options
  • Save thorsman99/b4450f51b20bf0887c2929bcad7c27c2 to your computer and use it in GitHub Desktop.
Save thorsman99/b4450f51b20bf0887c2929bcad7c27c2 to your computer and use it in GitHub Desktop.
Download ZIP
Rebuilds all sql indexes for a table #SQL
Raw
rebuildallindexes.sql
ALTER INDEX ALL ON Production.Product
REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,
STATISTICS_NORECOMPUTE = ON);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment