PrepAway - Latest Free Exam Questions & Answers

Which method should you use?

You have a database that uses stored procedures to perform INSERT, UPDATE, DELETE, and SELECT statements.
You are tasked with providing a recommendation of indexes to be created and dropped from the database.
You need to select the appropriate method to accomplish the task.
Which method should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
Index Usage DMVs

B.
Missing Index DMVs

C.
SQL Server Profiler

D.
Database Engine Tuning Advisor


Leave a Reply