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.
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
i learning more advanced concepts from you(your site)
thank lot
…………………..saravanan
Respected sir,
can u tell me how to create index and how we use that index
give one example
Respected sir
is ti possible to import a Excel file by writing the sql script…then tell me the script..please
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
Ankit,
Truncate can not be rolled back you can search about this at
http://blog.sqlauthority.com/search-sqlauthority/ and you will find that I am correct.
Kind Regards,
Pinal
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).
Your articles on SQL Server are simply adorable!
Keep the good work up Pinal!
Cheers!
hi pinal,
pls send me interview query and some important query that mostly used ..
Thanks
Ashok