Good Questions for SQL DBA Applicant

SQL Server Administration
1

HI experts,
Do you have a few good questions that could be asked of a SQL DBA applicant during the interview?
Maybe a mix of administration questions along with a couple of development questions as well.
Thanks for any suggestions.

2

Assuming the DBA is expected to have some level of experience:

  1. What is the difference between a view and an index? (A detailed DBA might point out that they can be the same thing, i.e., an indexed view).

  2. How do you get information about what SQL Server considers to be missing indexes? (If they say "query plan", ask them how to get it outside of a specific query.)

  3. When should you consider data compression for a table/index?

1 Like
3

Thanks @ScottPletcher Yes we want a good amount of admin experience, not so much in the development area. Thanks for your suggestions.