Advertisement
Guest User

Untitled

a guest
Dec 9th, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. SELECT distinct t.name
  2. ,create_date
  3. ,modify_date
  4. ,last_user_update
  5. ,user_updates
  6. ,last_user_lookup
  7. ,last_user_scan
  8. ,last_user_seek
  9. ,sum(user_lookups+user_seeks+user_scans) as user_reads
  10. ,sum(reserved_page_count * 8) as total_space_kb
  11. ,sum(used_page_count * 8) as used_space_kb
  12. ,sum((reserved_page_count-used_page_count) * 8) as unused_space_kb
  13. FROM sys.[tables] AS T
  14. left outer join sys.extended_properties on extended_properties.major_id=T.object_id
  15. left outer join sys.dm_db_index_usage_stats ius on ius.object_id=t.object_id and database_id = DB_ID()
  16. inner join sys.dm_db_partition_stats ps on ps.object_id=t.object_id
  17. WHERE T.[is_ms_shipped] = 0 and t.name='MY_TABLE'
  18. GROUP BY t.name
  19. ,create_date
  20. ,modify_date
  21. ,last_user_update
  22. ,user_updates
  23. ,last_user_lookup
  24. ,last_user_scan
  25. ,last_user_seek
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement