Which of the following is the correct Transact-SQL statement for achieving your goal?

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?

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:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Google

Google

Very handful of web-sites that come about to become comprehensive below, from our point of view are undoubtedly nicely really worth checking out.