Skip to contentSkip to footer

Sql Server Dba Interview Questions

Salaries
Interviews

169 sql server dba interview questions shared by candidates

The most difficult question was about my weaknesses. However, I have learned how to handle that particular question. Other difficult questions were technical in nature. For example, questions about web servers and dot net applications.
avatar

SQL Server Database Administrator

Interviewed at Oxford Global Resources

3.3★
Jul 28, 2013

The most difficult question was about my weaknesses. However, I have learned how to handle that particular question. Other difficult questions were technical in nature. For example, questions about web servers and dot net applications.

How would you identify a long running query? How would would find out the execution plan of that query? If you have a SPID how could you see what query that spid was executing? Name the types of waits in SQL-Server? What do they mean? Is there another way besides SQL Server Profiler, Extended Events and Performance Monitor to see waits, I/O, etc? What is the difference between an Implicit and Explicit query in SQL? With a large database using Blobs what sort of configuration changes do you have to make? How do you setup indexing specifically? What steps do you take to tune SQL queries? How would you go about rewriting a poorly performing query? How could you tell where indexes were missing? Why would you choose SQL-Server over Oracle?
avatar

SQL Server Database Administrator

Interviewed at MetLife

3.7★
Apr 20, 2016

How would you identify a long running query? How would would find out the execution plan of that query? If you have a SPID how could you see what query that spid was executing? Name the types of waits in SQL-Server? What do they mean? Is there another way besides SQL Server Profiler, Extended Events and Performance Monitor to see waits, I/O, etc? What is the difference between an Implicit and Explicit query in SQL? With a large database using Blobs what sort of configuration changes do you have to make? How do you setup indexing specifically? What steps do you take to tune SQL queries? How would you go about rewriting a poorly performing query? How could you tell where indexes were missing? Why would you choose SQL-Server over Oracle?

Viewing 41 - 50 interview questions

Glassdoor has 169 interview questions and reports from Sql server dba interviews. Prepare for your interview. Get hired. Love your job.