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.
Hi Pinal Dave
Oh God , how can i thank u….it was so helpfull, and i can’t forget u in this needfull Q and A. once again thank you very much…i will call u as SQL-GOD!!!!
Thanks and regards
prashanth venkataswamy
Can you please let me know how many thereads allow SQL Server to execute DTS packages?
Hi Dave,
Excellent work
Hi,
Excellent site. Thanks a lot. Please don’t forget to update it. Please come up with questions on SQL Server 2005.
Thanks,
Pradeep
Can’t Truncate statement be rolled back?
I was under the impression that Truncate works at pages, and removes the reference, however it can be rolled back.
Please clarify this.
Thanks in advance
Can u send me the SQL Server Faqs.
Excellent site!!!
It is gr8 deal of help for many!!!
Thanks a lot for having such a site with all this information!!
i am verry verry thanks for the Mr.P.Dave.that have sharirng of good collection of his exillent knowladge,once again verry verry thanks …..
NOTE :
To have a non custered index the t able must have a clustered index.
What are the different index configurations a table can have?
A table can have one of the following index configurations:
No indexes
A clustered index
A clustered index and many nonclustered indexes
A nonclustered index
Many nonclustered indexes
Thanks very much.
Great
Thanks
Venu Jakku
Developer
Hi,
Its Realy Nice question with answer.
Regards,
Anil CHauhan
Just found your site today while preparing for an interview. Thank you for the wonderful resource.
hi ,
i should say the best website for finding a lot on sql and rdbms thanks …
regards
tannu
a great collection of questions( thanks a lot for answers were also there)..
really help full for all..
Thanks for the questions, they are of immense help to a fresher like me!!
Please Send Me Sql Server Interview Faqs ASAP.
1) What is diff. between Sql server 200 and sql server 2005 .
2) Which is best wesite for Downloading Questions and answer for certifications.
hello,
Thanks for your good nature for sharing knowledge.You are nice person.
please give me brief description on View command. Can we change data in base table through view .
can we bound view so that a person cannot change base table through view.
hi,
This sql server interview question page is very useful.
pls send me Sql Server Interview Faqs ASAP.
Thanks,
Raj.
hi dave,
I am a sql freak like you are,and i have a query for you,am trying to find out a way to find top most parent of each child in the following table using one sql query and not any batch query,although oracle provides a way by using connect by prior,i dont see anything like that in sql server 2005 can u help me out ?????i hope you can…..cheers!!!!!
table1
child || Father
A || B
B || C
C || D
D || E
E || null
F || H
G || null
output
table1
child || Father
A || E
B || E
C || E
D || E
E || null
F || H
G || null
or anything which can be close to the recursion like finding out the topmost parent…