PrepAway - Latest Free Exam Questions & Answers

You administer a Microsoft SQL Server 2012 server. You plan to deploy new features…

You administer a Microsoft SQL Server 2012 server. You plan to deploy new features

to an application. You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.

What should you do?

A. Query the sys.dm_db_index_usage_stats DMV.

B. Query the sys.dm_db_missing_index_details DMV.

C. Use t

he Database Engine TuningAdvisor.

D. Query the sys.dm_db_missing_index_columns DMV.

Explanation:


Leave a Reply