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.
Thanks for help in SQL Interview Questions
Excellent….. I appreciate your tendency of sharing.
hello sir,
this is a very helpful site. please give some complex queries in sql server 2000 that are frequently asked in technical interviews.
with regards
rishikesh
Hi Dave
Can u plz send me the interview quetions with objective type
Regards
Riya
it is too much helpful for new comers who enters newly in it field and as possible as all topics gives help to provide job to them..
thank a lot
Tarun jain
how to add new column in existing table? pls answer me with code on my mail-id.. i will be very thankful to you.
Thank you
Tarun jain
Tahnks Dave
Your Articles Are Very Useful To Me And I Got So Much Of Information From Your Website. Thank U Very Much.
Regards
———-
Madhav Reddy
Hello Pinal Dave,
You are Great… Your information is very valuable an easy to understanding.
ekarimnagar.com Team
Hello Sir,
Suppose i dont take latest backup the databse.
and the log file may be corrupted.
The database is now on Suspect Mode.
So how can i Recover my database(I have no backup) ?
pls tell me the procedure
Thanks for u r work .I need SSRS interview Questions also if u have any thing realated please mail me .I m preparing for interview
Hi Pinal,
You wrote in your resume that you “… wrote Performance Tuning guidelines…”
Could you please e-mail me this document, or in case if it is placed on this site could you please point me to its link ?
Thanks,
Mark
Hi,
I really appreciate the hard work of yours by putting the effort in collecting the the important questions and providing the solutions also.
All the best and good luck
Resp, Sir
I want to create RSS for the site
So, How can i create, publish, and maintain on the site.
please give me the code if possible, or references of site name
which gives code.
Yogesh
hi, i am ankur MCA student from ahmedabad.
i have a problem releted with rss.
how to make Rss and how to put into this Rss to our site.
plze give me the coding to make Rss.and tell me the easy way how to make it easy to Rss
plze send any answer then send me my email me..ok
bye
ankur
Hello Dave,
can you send me the frequently asked sql queries in interviews.
thanks
Anurag
Dear Pinal,
I have visited your web-site today itself and have found it very helpful.
My problem is that I have experience of 10+ years (in DOS-based applications like Clipper, Foxpro etc) and all logics are
clear and I have developed application softwares for almost
every field and are being used in the market. But I donot have any degree or diploma.
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.
Best Regards,
ASHU
hai nice website
Hi Pinal,
I looked at your website, it really is nice. In addition to fundamentals of database. Do you in case have a list of sql excercises we can try for say Employee,Department example.
Things where someone needs to think hard. It could be a good excercise in problem solving.
For instance, how to delete duplicate rows from a table. Questions like that..
Let me know what you think.
Thanks
Regards,
informer
hi dave,
i am new to sql server 2005.
can you please tell how to display error message in the result set when the data is not available in the table.
when i trying select data of one perticular column from db table if there is no record i want to display error message saying that this recored is not available so how to write query…
eg:if there are 10 emp_id from emp tb if i select emp_id from emp where emp_id=11
in the result set i need display 11 not available
thanks in advance