Interview with Jim Gray

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.

Source:Jack Vamvas (http://www.sqlserver-dba.com)

Senior SQL Server DBA questions

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?

Read Also

Diary of a SQL Server DBA – Num 1

SQL Server Performance Killers