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
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
plz guide me about the queries put in interview for sql-2000.
Hi Pinal,
I’m working on SQL Server 2005, I want to know how can jobs and schedules be run on SQL server.
I wrote a job as below:
#HEADER
Job_Name=MD0898
Server=NT0SUCP1
#
STEP1
module=isql
db_server=NT0SUCP1
userid=planogbatch
sql=MD089801.sql
mode=no_report
#
FOOTER
this job executes a stored procedure and execute cmd for SP is in MD089801.sql file.
I wan’t to know how to run this job and can I create a daily schedule to run this job in SQL server. We are using mainframe as well in our project, will these jobs be executed by mainframe.
Thanks in advance..
Regards
Monika
Can You please send me those links of SQL Interview Questions
Hi Mr. Dave,
I have some experience with Databases but I didn’t spend a lot of time working on the same. My job was to install a Database server, creating Replication, taking Backups/ Restore database in development, testing and support environment, which I did mostly using SSMS (Management Studio / Enterprise Manager for SQL 2000).
I want to switch my career into Database Administration and to be specific in T-SQL. Could you please help me in that? I want to know, if you have any series of articles describing the basics of T-SQL. It will be great if you could forward the links to me along with any related document.
Waiting for your response.
Thanks & Regards,
Sudeepta.
Hi Pinal,
The question and answers are very helpful. Thank you!!
Shanti.
hi dave,
past ten days i saw your website, very helpful for me….. i studying Sql server2005 in beginner stage…. and can you quide me…….
thanks verymuch
With Regards
S.Ram.,
Respected sir,
can u tell me how to create index and how we use that index
give one example
Many thanks Sir! Most appreciated, your sound advise and interview prep material has helped me a lot.
You’re awesome!
Kind Regards,
Omar
Hi Mr. Dave,
How to use in PIOVT in SQL server 2000.
Hello Pinal
I just downloaded your interview Question collection. Its really good to help all.
It is really appreciating.
But i want to say something , there is erro in answer of one question.
You wrote difference between truncate and delete command. There is written that truncate can not be rollback, but i implement on my system that trucate can also be rollbacked.
So please update it.
thanks
Hai dave,
Really a excellent work……
By seeing the information i understand many things……
I am searching job in Oracle filed, just now only i had finished orcale DBA, But i feel difficulty in seeking the Job in this filed, bcoz many of the organisation asking fo experienced person only and not for the fresher..
If you give me some tips., It may be helpful to me….
Thanks & Regads
Saravana
hi,
can u tell me ,
how to retrieve the nearest value from a table in sql?
hi i like this site plz send me FAQ in sqlserver 2000 and 2005.Thanks
hi this is very useful to all
Hi Pinaldave,
thanx for your this kind of help.these are very helpful to me to attend Interview.really very very thank u.
Suresh(Technical Support Engineer,Singapore).