Skip to content

Instantly share code, notes, and snippets.

@ArtemAvramenko

ArtemAvramenko/index_stats.sql

Created September 21, 2016 11:40
Show Gist options
  • Save ArtemAvramenko/b7a785dad007c4614f8beee15ef2ba95 to your computer and use it in GitHub Desktop.
Save ArtemAvramenko/b7a785dad007c4614f8beee15ef2ba95 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
index_stats.sql
SELECT o.name, i.name, ddius.* FROM sys.dm_db_index_usage_stats ddius
JOIN sys.indexes i ON ddius.object_id = i.object_id AND ddius.index_id = i.index_id
JOIN sys.objects o ON i.object_id = o.object_id
WHERE ddius.database_id = DB_ID()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment