Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT distinct t.name
- ,create_date
- ,modify_date
- ,last_user_update
- ,user_updates
- ,last_user_lookup
- ,last_user_scan
- ,last_user_seek
- ,sum(user_lookups+user_seeks+user_scans) as user_reads
- ,sum(reserved_page_count * 8) as total_space_kb
- ,sum(used_page_count * 8) as used_space_kb
- ,sum((reserved_page_count-used_page_count) * 8) as unused_space_kb
- FROM sys.[tables] AS T
- left outer join sys.extended_properties on extended_properties.major_id=T.object_id
- left outer join sys.dm_db_index_usage_stats ius on ius.object_id=t.object_id and database_id = DB_ID()
- inner join sys.dm_db_partition_stats ps on ps.object_id=t.object_id
- WHERE T.[is_ms_shipped] = 0 and t.name='MY_TABLE'
- GROUP BY t.name
- ,create_date
- ,modify_date
- ,last_user_update
- ,user_updates
- ,last_user_lookup
- ,last_user_scan
- ,last_user_seek
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement