Skip to content

Instantly share code, notes, and snippets.

/IncrementalStats.sql

Created October 19, 2015 16:27
Show Gist options
  • Save anonymous/19c4aee148cc72a9d9b5 to your computer and use it in GitHub Desktop.
Save anonymous/19c4aee148cc72a9d9b5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
IncrementalStats.sql
-- Most recent partition (filtered by rows > 0), 61MM rows
-- CPU time = 1044204 ms, elapsed time = 77326 ms.
UPDATE STATISTICS dbo.myPartitionedTable WITH RESAMPLE ON PARTITIONS(1196)
GO
-- Previous partition, 64MM rows
-- CPU time = 1085060 ms, elapsed time = 77782 ms.
UPDATE STATISTICS dbo.myPartitionedTable WITH RESAMPLE ON PARTITIONS(1195)
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment