thorsman99/rebuildallindexes.sql

Created October 1, 2017 03:10

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/thorsman99/b4450f51b20bf0887c2929bcad7c27c2.js"></script>
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