14. You’re responsible for SQL Server performance and one of the developers
reports INSERTS are particularly slow. You suspect that a previous developer has
created some redundant nonclustered indexes and these are hindering INSERT
performance. How can you tell if an index is used?
A. Sys.dm_db_index_usage_stats
B. Sys.dm_db_index_request_count
C. Sys.dm_redundant_indexes
D. Sys.dm_db_missing_index_details
Bạn đang xem 14. - THE REAL MTCS SQL SERVER 2008 EXAM 70/432 PREP KIT- P126 PPTX