Interview Questions and Answers are now updated with the latest questions and answers. New Location: SQL Server Interview Questions and Answers. The old Questions and Answers Complete List Download page is kept below.
Click here to get free chapters (PDF) in the mailbox
Thank you all for your appreciation about the my recent series of SQL Server Interview Questions and Answers. I enjoyed writing questions and answers. I have gotten many emails about complete series.
Top most requests were to collect series in one big post so they can be easily used. I was asked to provide links to download them so they can be printed and referred.
Another question I received is done I ask the same questions in interviews which I administrate. The answer is YES. Though, I have a few other questions, which I ask. All of them, I came up myself and answers are unique to questions and not available on-line. Well, long story short, I have compiled list of questions in one PDF. Please download them and use them in your next interview or just for reading purpose.
An interview Question and Answer discussion can be very helpful to both these individuals. It is simply a way to go back over the building blocks of a topic. Many times a simple review like this will help “jog” your memory, and all those previously-memorized facts will come flooding back to you. It is not a way to re-learn a topic, but a way to remind yourself of what you already know.
Download SQL Server Interview Question and Answers Complete List
Complete Series of SQL Server Interview Questions and Answers
Introduction, Part 1, Part 2, Part 3, Part 4, Part 5, Part 6
SQL Server Interview Question and Answers Complete List Download
Other popular Series
SQL SERVER Database Coding Standards and Guidelines Complete List Download
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
Connect with me on Twitter.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
282 Comments.
Send me the SQL server Qans.
This is simply Superb to give such an information for the beginers as well as experts.
I have updated myself recently with new languages and now i am working with a company as a ERP programmer using SQL-Server 2000 and VB-2005. Please guide me accordingly so that I can see my future brighten. I belong to a small city but close to NCR.
I will be very thankful
Regards
SRINIVASA RAO
BHANUTEJ
How can we write a trigger so that before any insert is occured on a table it must check for certain values to be supplied for a table.If coorect insert, else not.
Plz Send me SQL Interview Questions
hi
can you pls send me SQL server interview question & answers
thanks
superb—————–
u r gr8,thnks a lot.
are there any interview questions for reporting services
could u plz send me interview questions asked in HR round regading urself, strenth & weaknesses etc
Thanks man. You are great.
Great links, questions and anwsers thanks for the info.
john
Hi Dave,
I always come to this site whenever i stuck somewhere.
You have taken gud initiative. Its realy helpful not only for persons who are looking for job also for others.
Just 1 week back i started to give some interviews. I find they are more concern with Database performance issues. I’m having 3 years of total it experience. So they didn’t ask me general database questions.
So can you please give some Q/A regarding DB performance.
Regards
Vineeta Agarwal
It is realy great, excellent web site.
Srinath.
DBA
Bangalore
Hi Pinal,
Thanks a lot for your interview questions. :)
your answers are good
Hi Pinal
Ur suggestions are really very good.
Great collection.
Thanks.
Hi
Pls Could u Send Me SQL Server Interview Questions and Answers
I am facing a problem of transaction lock in sql server2000. The situation is when two persons work together on same record at same time transaction lock problem comes. How to avoid this. v have developed the software in vb.net(visual studio2005) running on LAN. kindly help.
Can u send me the SQL Server Faqs.
Hi Pinal,
Great set of questions, but I think there are a couple that may not be entirely correct.
A Heap is a table with no CLustered Index. If a Heap has a non-clustered index on it, its still a Heap (Kalen Delaney, Inside SQL Server 2000, Ch9, Data Modification Internals).
The use of NOLOCK should be used with extreme care and IMHO it isn’t considered good practice to use it generally. Itzik Ben Gan demonstrated some issues when using NOLOCK in the UK back in 2006 at Microsoft (see , , and ).
I hope you don’t mind me mentioning these, and if you disagree thats fine, but if you could supply some references that would be great – then I can learn too :)
Regards
Anon