Enjoy this post? Enter your email address for updates on new posts:
Delivered by FeedBurner
Email +Jack Vamvas at firstname.lastname@example.org
Maybe a lot of you have read this interview with Jim Gray . I hadn't ever read it before but was blown away. Storage, transactional pocessing,theory , he covers a lot of topics with very concise but penetrating responses.
Posted at 06:59 AM in Interviews | Permalink
Senior SQL Server DBA interviews should focus on thought processes and troubleshooting approaches.
SQL Server Architecture, Memory,Storage,Locking and Latches, SQL Server performance are subjects the Senior DBA must be an expert. Or have enough experience to develop an approach for troubleshooting.
This list is based on either questions I've been asked in interviews or questions fellow DBAs have been asked.Add your questions to the comments and I'll add them to the list
1.Why should you not put a clustered index on your Identity column?
2.Given a Authors table , how would you find the author with the 3rd highest book sales?
3.What is a CROSS JOIN? Explain and give an example
4.Explain statistics. How often are they updated?
5.If confronted with a sudden poorly running query , how would you troubleshoot?
6.Is there a difference between a Primary Key and a Unique Key?
Diary of a SQL Server DBA – Num 1
SQL Server Performance Killers
Posted at 12:20 AM in Interviews, Jobs | Permalink
database interview questions, interview questions answers, job interview, questions for interview, sql interview questions