Skip to content

Instantly share code, notes, and snippets.

@umair-me

umair-me/rebuild_indexes.sql

Created August 28, 2015 09:59
Show Gist options
  • Save umair-me/c82c2931d30f1f7053fe to your computer and use it in GitHub Desktop.
Save umair-me/c82c2931d30f1f7053fe to your computer and use it in GitHub Desktop.
Download ZIP
Rebuild indexes sql server
Raw
rebuild_indexes.sql
-- Re Index
EXEC sp_MSforeachtable "dbcc dbreindex('?', '')"
-- Update Stats
--EXEC sp_updatestats
-- or
EXEC sp_MSforeachtable "UPDATE STATISTICS ? WITH FULLSCAN"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment