You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
ABC.com has an existing SQL Server 2012 database that has multiple tables. These tables are
configured to contain a single index for every column.
When you are informed that item creation is slow, you decide to find unused indexes.
Which of the following is the correct Transact-SQL statement for achieving your goal?
A.
The sys.dm_db_missing_index_groups Transact-SQL statement.
B.
The sys.dm_db_missing_index_details Transact-SQL statement.
C.
The sys.dm_db_index_usage_stats Transact-SQL statement.
D.
The sys.dm_db_missing_index_columns Transact-SQL statement.
Explanation:
http://technet.microsoft.com/en-us/library/ms188755.aspx
Very handful of web-sites that come about to become comprehensive below, from our point of view are undoubtedly nicely really worth checking out.