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
HI Dave,
I want to make a good career in DBA so will you please tell me what will I do to get good career in MS SQL
Could you please guide me what I do for getting more knowledge in SQL
Please give me advice.
hello sir,
your articles are very nice and all
the students of sql server are enjoyed a lot
Thanks!!!
I am getting this kind of error. during the installation i didnt give any login name and password . so what to enter here as login name i dont know.i tried some of them ur solution still give me same error. My Os is window vista and if i try to see service from computer management does not give me service of sql server.
please help me out.
TITLE: Connect to Server
——————————
Cannot connect to 76.194.236.194.
——————————
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 3)
Hi,
I was going thru your interview question collection. In your question “What is difference between DELETE & TRUNCATE commands?” you have mentioned that “TRUNCATE cannot be rolled back”. But I believe this in NOT true and we can rollback a truncate statement.
For example:
Create table #test (I int)
Insert into #test values (1)
Begin tran
Truncate table #test
Rollback
Select * from #test
Drop table #test
The above code snippet returns a value 1. Could you please tell me how this is possible?
Regards,
Rakesh
The Truncate command inside a trasaction can be rolled back as it is clear from the example you have given
Thank you for the Q&A pdf. This is really precise and very helpful.
i want to build my career in database.
could u tell me for which certification should i go?
i mean ORACLE or SQL2008.
someone told me that sqlserver2008 will be the best. i m getting confused. pls suggest me.
I m pursuing MCA final year from regular.
thanks
paramjeet singh
I want to learn SQL 2008 and installed, but no front end, like query analyzer, or query developer installed, am I missing something, I tried installing the SQL Management Studio_x86_ENU studio but none looks like installed on my system, my operating system is Windows Vista Ultimate.
Please, guide me, your help is appreciated. – Thank you.
Best regards
udmalla
While installing version 2008 did you get any errors?
What did you mean by ” none looks like installed on my system”?
I have install sql server 2005 in vista ultmate without any problem but not any database is install tell me how can I intall the database and I am not able to write any sql query.
Dear @param,
It has been observed that microsoft copies the idea from other softwares or products and make their own one.
However, I’d recommend that If you are really interested in database then you should go for Oracle.
There’s so many reasons but I’ll not going in depth.
Thanks!
Really awesome help.
Hey!
Brilliant blog!
Thanks for the pdf!
Regards,
Shravan.
Thanks so much for the Questions and Answers
Thanks again!!!!
Anks
Pinal sir.. great work …
Hi Pinal,
I want to get certification for SQL Server 2005/2008. Can you please provide me the reading material for the same.
Thanks,
Hi Dave
An excellent work and very useful material.
thanks for providing
& Congrats on having baby
Hi Pinal ,
I have written the query in MDX Query Editor in SOL Server 2008 Successfully,
But the problem is when we implement the same query in Cube(as expression in calculated measure) its not working in SSAS 2008
The Error is:- Select statement is not correct in MDX Expression
nice job! your Q&A is most appreciated
Thanks
Hi Pinal,
I have a query for you, Can we write a select query to select only nth row from a table without using where clause?
This question was asked to me in one of my interview.
Regards,
Ashwin Shende
Yes we can get 200th row from the table Virus
in following way.
I am ordering on column nam virusname by descending order and then getting first row.
select top 1 * from (
select top 200 * from virus
order by virusname
desc
) as temp
just try it..
Why is it “without using where clause”?
Refer this to know more methods
@Ashwin
Without a WHERE clause? That’s an interesting question. That answer is yes, though it is inefficient. If the only the second record is wanted:
DECLARE @A TABLE (A INT);
INSERT INTO @A SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3;
SELECT TOP(1)
A
FROM
(
SELECT TOP(2)
A
FROM
@A
ORDER BY
A
) A
ORDER BY
A DESC;
Thanks a Lot :-)