Interview Questions and Answers are now updated with the latest questions and answers. New Location: SQL Server Interview Questions and Answers.
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.
Reference: Pinal Dave (https://blog.sqlauthority.com)
282 Comments.
Thank you,
These questions are extremely helpful for me beacause I am applying for different software companies. These questions will be helpful for me for giving interviews.
Hi Dave,
how is it possible to use nested transaction with sql 2000.
Please help
Thanks and Regards,
omprakash
Hi Friends
We are very thankful to PInal Dave for the site, its really wonderful. Hope lots of people gets benifitted from the site. use as readymade information.
Thanks and Regards,
Appalaraju Kusumpudi
This is very much help ful to me. thank u.
Now iam complete my M.C.A and searching for a job. I have very much interested to working under SQL server.
Thank u very much i am satisfy to u r help on que and ans
Hi Pinal,
Thank you very very very very much. I passed my final written interview exam of sql server today. Tomorrow I will start my new job. It was open book and I was allowed only one book. I used your q & a. You are good.
Narayan Satya
very good questions
Thanks
Nice website i learned more about SQL
with regards
kalai
These questions are extremely helpful for me beacause I am applying for different software companies. These questions will be helpful for me for giving interviews.
Its keep me upgrading myself.
Thanks and keep it up.
Its Really Very helpful site.
Hi
How to find the first 50 highest values
How to find the nth maximum value and minimum value
How to concatinate one integer value and string value
pls reply me
u r friend
I need help for cursors and triggers in sql server with synatx and some sample example.
i have done software engineering and i m preparing for the interview so please send me some quetions which is related to my course.
Nice job ;-)
very nice collection.
Hi to Pinal Dave and every one,
Do u have complete notes and Interview questions on SSRS and SSIS?
can u plz give me a reply
Thanks
santu
Hi Dave
i am working as sql DBA in one company having 1 yr exp , please post me some gud monitoring scripts & suggest me to improve my knowledge in sql server as a DBA
i found many answers without taking risk.I worship you
thanks a lot..
Mr. Dave,
This is great collection of questions and answers. Today I passed interview. All questions are from your list.
1) Difference between Truncate vs Delete
2) Normalization advantages
3) Having condition
4) Unique constraint
5) Constraint and rules
You just got this thing right. I passed interview because of YOU. YOU are the man!
Bob Lafore
Hello,
Great work! Certainly gonna help with my interviews :)
Thank you!
Hi Pinal,
Thank you very much for this document. It really helps me a lot..
But one thing still confusing me now…
in question
What is difference between DELETE & TRUNCATE commands?
in answer it is also given that
TRUNCATE can not be Rolled back.
is it true ? i think we can rollback it. please give me details about this…
thanks
Ajeesh