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. Here is the Interview Questions and Answers Complete List for SQL Server 2008.
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.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
160 Comments. Leave new
Friends
in case of outside the transaction ..you can only rollback delete not truncate.
thnx
@Ankur, have to tested this at your end or are you just spreading word of mouth.
Can you show us how can do do that? Like an example.
Thanks you so… much . I’m appreciating your work .
Keep doing
Hi Sir
please send me interview question (frequently asked).
Hi Sir
Can you send me the sql server 2008 s/w link to my mail-id
please…
Hi Pinal,
Is there any levels for Recursive CTE like stored procedures?
How many levels we can go?
Thanks,
Anand
It can go to any level but you need to specify the max recursion option to 0
Hi Pinal,
Thanks for putting this together. However I’m having a problem printing the PDF.
It’s security protected (DRM) preventing it from being copied or printed.
Thanks
Adam,
did you ever get a reply?
Thanks a Million
It’s Really Gr8 Job
Good job dude.
Questions are very good but answer does not sound good.
Any how gr8 work.
Hi Sir,
I have done mcom i was working as mis reporting in excel , company got relocated i was in search of job someone suggested me do course in oracle DBA …I finished my course can u suggest me how shld i study… and prepare for interview and pls send me interview question to my mail id….pls i am physically challenge girl i am struggle to find job…
Thanks for this post; it’s really helpful.
HELLO SIR,
HOW TO MAKE UNION OF “2 IF CONDITION” QUERIES?
FOR EXAMPLE:
IF(J=J)
BEGIN
SELECT ID,* FROM TABLE1
END
UNION
IF(I=I)
BEGIN
SELECT ID,* FROM TABLE2
END
WITH GROUPBY ID
Put the IF condition in the WHERE clause of each query
sir,
What is difrrences in sql server backup and windows backup.
hi., some one plz suggest me a project on Oracle 10g (for B.tech final year project)
Great work, good basic set of questions. It is great that I can download them. I can see preventing the changing of the document, but preventing the printing is a little overboard. if I can download, why cant I print?
I use your questions a a reference point to what topics I really want to touch on during an interview. I do not always have a computer nearby.
Pinal you are king of SQL and SQL server!
amazing website, thanks for sharing your knowledge with us
cheers
C
Hi,
In Change Data Capture What is Diffrence Between $start_lsn And $eqval
Hi
After creating the cdc (table_CT) table that is genrated in system table cant Be Modified Means It Dosnt have Design option in sql server 2008
Can Anybody Give Me Solution For This
Hi,
I am using SQL SERVER 2008 R2. In that i was created the job for taking the back up. It was working from the day of it is created. But from the last week it was not executed and also it shows error” Execution Failed.,See the Maintanence Plan and SQL Server Agent Job History logs for details”
Please let me know why it happens? What is the solution to resolve this?
See if the SQL Server agent is running. Also check if the password got changed for the account that runs a job
Is it possible to add an application develped in VB.net & SQLServer2008 to system startup..???
why we use indexes in sql server 2008. please let me know in detail.