Skip to content

Instantly share code, notes, and snippets.

@ronascentes

ronascentes/update_stats.sql

Created November 11, 2016 18:44
Show Gist options
  • Save ronascentes/060ca426315df597679cb4b51278e899 to your computer and use it in GitHub Desktop.
Save ronascentes/060ca426315df597679cb4b51278e899 to your computer and use it in GitHub Desktop.
Download ZIP
Update statistics
Raw
update_stats.sql
EXEC SP_CONFIGURE
EXEC SP_CONFIGURE 'max degree of parallelism', 8
RECONFIGURE WITH OVERRIDE
EXEC sp_updatestats @resample = 'resample'
EXEC SP_CONFIGURE 'max degree of parallelism', 6
RECONFIGURE WITH OVERRIDE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment