The interview is a very important event for any person. A good interview leads to good career if the candidate is willing to learn. I always enjoy interviewing questions and answers series. This is my very humble attempt to write SQL Server 2008 interview questions and answers. SQL Server is a very large subject and not everything is usually asked in interview. In interview what matters the most is the learning attitude.
Interview Questions
An interview Question and Answer discussion can be beneficial 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.
I have listed all the series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download. If you have any question or if you want to add to any of the questions, please send me a mail or write a comment about interview questions.
Click here to get free chapters (PDF) in the mailbox
You can also connect with me on Twitter.
Reference: Pinal Dave (https://blog.sqlauthority.com)
160 Comments. Leave new
I’m very new to SQL server. Could you please guide with any training materials. Thank you
…Ek Dum Jhakaas….Really Good Job….Thanks
Vande Matram…
Regards
Mitesh Neema
INDIA
Please, i want to knew what is sql jobs?
Read about Jobs in SQL Server help file
It is a good start to know the informations
Pinal,
Good job. This helped me a lot.
Regrds,
Sreeni
hi
i need sqlserver question and answer for middle stage
can you send ssis and DTS packages diff.
thanks
vinay
Many thanks
Thank You Pinal …
Sql 2008 Qns are really helpful
Dave, i take issue with this statement: “Identity/GUID columns do not need to be indexed.” I will agree the statement is correct IF YOU NEVER USE THE COLUMN (but then i would submit the column exists for no valid reason, and that’s a different discussion).
Often, the identity column is used as a surrogate primary key (and very often because the table designer was too lazy to figure out what data element(s) uniquely identify the row — again, a different discussion).
If the identity column is used as a primary key in this table, and then as a foreign key in other tables, the identity column must ABSOLUTELY be indexed (unless the table is so small that it is always in memory… or unless you enjoy table scans).
there is no automatic creation of an index on an identity column, and there is no automatic clustering of data based upon that identity column.
hello,
how r u, i have a request based on sql server. how to insert bulk records into the data base? i know how to insert one record at a time
You can have data in a text and use bulk insert to copy data to a table. Refer this post for more informations
@Swetha,
Bulk Insert inserts huge number of records from another source (outside SQL Server) into SQL Server.
Why you want to use Bulk Insert when you want to insert one record at a time.
What is the your requirement why you want to insert one record at a time, Of-course there are many ways of doing it
But why use Bulk Insert when you do not want to take advantage of its features ?
Please provide us more details so that we can suggest you most optimal solution.
~ IM.
Hi, Pinal
We are considering to migrate from SQL Server 2000 to 2008. I think the version 2008 should be backward compatible.
Would like to check is there any changes like those command being used in 2000 could not be used (not supported) in the version 2008? as I overheard in the past where some of the version 2000 cmd no longer applicable in version 2008.
I need your advice,pls.
THanks in advance.
Hello Avalyn,
You can identify the possible issues using Microsoft’s SQL Server 2008 Upgrade Advisor tool.
Regards,
Pinal Dave
This is very good and useful. if you give with an example mean it is very useful.
Thanks a lot, Pinal ;)
Very nice, Pinal.
I noticed that most of the questions are
‘What is……?’
What about more deep knowledge questions
like ‘Why … ?’
And maybe it worth to divide the questions that
relevant to Applicative(development) DBAs and for Production(Infrastructure) DBAs?
For example:
Thanks.
sql connection related problem
Hi Pinal,
I have learnt lot of thing from your site.
I want to know more about performance tuning in sql server 2005. What is the possible questions on performance tuning.
Please let me know if it is possible.
syed
Dear
pinal
I am looking forward to change . so for that i need sql server 2005 question and answer
regards
syed
Hi Dave,
I am fresher, I want to know the usage of
SET ANSI_PADDING ON/OFF
with clear explanation and practical example
Many thanks & regards in advance,
Naveen
Ttype SET ANSI_PADDING at SQL Server help file
It has explanation with example codes
Thank you sir.