- select object_name(object_id),* sys.dm_db_index_usage_state where user_seeks=0 and user_scans=0 and user_lookups=0 and system_seeks=0 and system_scans=0 and system_lookups=0 and object_name(object_id) is not null
- --该片段来自于http://www.codesnippet.cn/detail/070420132737.html
来源: http://www.codesnippet.cn/detail/070420132737.html