Skip to content

Instantly share code, notes, and snippets.

@dougajmcdonald

dougajmcdonald/When was the last Statistics Update

Last active August 29, 2015 14:08
Show Gist options
  • Save dougajmcdonald/de9815bc9b85e5d4e223 to your computer and use it in GitHub Desktop.
Save dougajmcdonald/de9815bc9b85e5d4e223 to your computer and use it in GitHub Desktop.
Download ZIP
When was the last Statistics Update
Raw
When was the last Statistics Update
SELECT 'Index Name' = i.name, 'Statistics Date' = STATS_DATE(i.object_id, i.index_id)
FROM sys.objects o
JOIN sys.indexes i ON o.name in
(
SELECT
name
--*
FROM
sys.objects
)
AND o.object_id = i.object_id
order by 'Statistics Date'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment