Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -31,7 +31,8 @@
31	31	{{code language="sql"}}
32	32
33	33	SELECT
34		- objects.name AS Table_name,
	34	+ schema_name(objects.schema_id) schema_name,
	35	+ objects.name AS Table_name,
35	35	indexes.name AS Index_name,
36	36	dm_db_index_usage_stats.user_seeks,
37	37	dm_db_index_usage_stats.user_scans,
...	...	@@ -43,7 +43,7 @@
43	43	WHERE
44	44	indexes.is_primary_key = 0 --This line excludes primary key constarint
45	45	AND
46		- indexes. is_unique = 0 --This line excludes unique key constarint
	47	+ indexes.is_unique = 0 --This line excludes unique key constarint
47	47	AND
48	48	dm_db_index_usage_stats.user_updates <> 0 -- This line excludes indexes SQL Server hasn’t done any work with
49	49	AND