Interview Questions

1. How can we identify Index usage history?

sys.dm_db_index_usage_stats – Returns counts of different types of index operations and the time each type of operation was last performed. 

By Hena Parveen 2 0
Is this helpful? Yes No

Submit an interview question

Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.

Get Started

Comments

Leave a Comment


Check out more interview questions

Based on your skills

MS SQL Server

3630294 1720 96 859

Angular

84077 92 0 46

Wordpress

70854 72 1 36