Posted by: smoothcriminal November 15, 2008
SQL Server DBA
Login in to Rate this Post:     1       ?         Liked by

Most of Tech- interview questions I ask to candidate while screening:

SQL DBA

1)Explain about yourself regarding SQL Server exposure.(This question filters out  many candidates with the way they communicate.Remember you can estimate his/her experience with 2-3 sentences.)

2)How do you resolve when developers comes infront of you and say query is running really slow or server is running slow?

3) How do you measure memory pressure ? Be specific

4)What do you call table without clustered index? When do you need Clustered index in table?

5)What is difference between Deadlocking and locking? What resolves them?

6) How do you remove Bookmark lookup in Execution plan?

7) What permission you need to truncate table?

8)Explain database backups and recovery scenerio?

9) What is most difficult scenerio you have faced in your professional career as SQL DBA? and how did you resolve it?

continue......

Read Full Discussion Thread for this article