Summary

• Page properties (3 modified, 0 added, 0 removed)
• Objects (0 modified, 1 added, 0 removed)
  • XWiki.XWikiComments[0]

Details

Page properties

Parent

...	...	@@ -1,1 +1,1 @@
1		-Technical Documentation.analysis.sql-performance.WebHome
	1	+Technical Documentation.analysis.sql.sql-performance.WebHome

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.rudim
	1	+XWiki.gideonl

Content

...	...	@@ -30,8 +30,11 @@
30	30
31	31	{{code language="sql"}}
32	32
	33	+--// https://www.sqlshack.com/how-to-identify-and-monitor-unused-indexes-in-sql-server/
	34	+
33	33	SELECT
34		- objects.name AS Table_name,
	36	+ schema_name(objects.schema_id) schema_name,
	37	+ 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
	49	+ 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

XWiki.XWikiComments[0]

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.gideonl

Comment

...	...	@@ -1,0 +1,1 @@
	1	+{{mention reference="XWiki.rudim" style="FULL_NAME" anchor="XWiki-rudim-z3bw3b"/}} should these not be on the DBG schema?

Date

...	...	@@ -1,0 +1,1 @@
	1	+2022-12-03 05:28:56.355