Hi Experts

[SUBBU]

i have some doubts please clarify

1. What is the difference between cluster installation for SQL Server 2005 and SQL Server 2008?

2. Log shipping has been set up new and is running fine. All on a sudden during the after hours, it starts failing. What could be the possible reasons?

3. There is excessive performance issues on a database server. What are the steps taken for the analysis and resolution?

4. Disk drive where data files (.mdf and .ndf) reside have crashed. We need to do the point in time recovery. List the steps taken in order to achieve this.

5. What would be the ideal disk layout for a SQL Server Database installation?

6. Running SQL Profiler for troubleshooting is causing high performance issues. What are the alernatives?

7. What all are the possible methods by which we can restore a database to another instance?

8. What is High Availability and what solutions could be implemented on SQL Server to achieve this?

9. You need to restart SQL Server services on an Active node in a two node cluster. How would you do it?

10. How would you patch SQL Servers in a fail-over cluster?

11. What is /3G, /PAE & AWE?

12. How to optimise memory usage in a multi instance SQL Server?

13. What is the default port in SQL Server, how to find it and how to reconfigure it?

14. What all are the system databases in SQL Server 2008?

15. What is the difference between index Re-org and index Rebuild?

16. What is the fundamental unit of storage in SQL Server data files and what is it’s size?

17. What is the fundamental unit of storage in SQL Server log files and what is it’s size?

18. How to perform point in time restore for a database in Simple Recovery Model?

19. Difference between Truncate and Delete?

20. How to troubleshoot a poor performing query?

21. What is blocking / deadlock ? How to troubleshoot and fix them?

22. List out the maintenance plan steps that you would accomodate for any database?

[Erland Sommarskog]

SUBBU (nsubb...@gmail.com) writes:
> i have some doubts please clarify
>

Too many questions to answer all at the same time. Besides I doubt
that you came up with all those questions yourself, but you have
been asked to answer them, and now you are cheating.

Many of the questions are also of the broad type where you will need
actual knowledge to answer the interviewer. So I will only cover one
question, and give you a hint:

> 18. How to perform point in time restore for a database in Simple
> Recovery Model?

The answer is: you don't.

--
Erland Sommarskog, Stockholm, esq...@sommarskog.se

[SUBBU]

Hi Expert am not a cheater. i have to learning for these qs.already learnt sqldba with fullfledge.but now i forget all subj bcz some gap after learning and spend time in my hometime and some problem is dre.that'y am asking u.

i have some doubts please clarify

> 2. Log shipping has been set up new and is running fine. All on a sudden during the after hours, it starts failing. What could be the possible reasons?

> 3. There is excessive performance issues on a database server. What are the steps taken for the analysis and resolution?

> 6. Running SQL Profiler for troubleshooting is causing high performance issues. What are the alernatives?

> 8. What is High Availability and what solutions could be implemented on SQL Server to achieve this?

> 9. You need to restart SQL Server services on an Active node in a two node cluster. How would you do it?

> 10. How would you patch SQL Servers in a fail-over cluster?

[rja.ca...@gmail.com]

On Saturday, 18 May 2013 07:23:39 UTC+1, n wrote:
> Hi Expert am not a cheater. i have to learning for these qs.already learnt sqldba with fullfledge.but now i forget all subj bcz some gap after learning and spend time in my hometime and some problem is dre.that'y am asking u.
>
> i have some doubts please clarify

I don't fully understand what you are saying in English.
I suppose that you may not understand what I say, too.

This is a large set of exam questions, and the answer
to cover everything is, "Read the manual".
The current and previous versions of Microsoft
SQL Server have large manuals at this web page address:
<http://msdn.microsoft.com/en-us/library/ms130214.aspx>
You don't have to read the whole of the manual,
but you must read many pages in order to understand
SQL Server well.

There also are separate web sites where you can find
answers for common problems. These are based on the
manuals, since they are written by people who have
read the manuals. And there are introductory
teach-yourself courses free online, too.

[Erland Sommarskog]

SUBBU (nsubb...@gmail.com) writes:
> Hi Expert am not a cheater. i have to learning for these qs.already
> learnt sqldba with fullfledge.but now i forget all subj bcz some gap
> after learning and spend time in my hometime and some problem is
> dre.that'y am asking u. i have some doubts please clarify

The idea I have with newsgroups and forums is that if you have a
specific problem, you should be able to get help. On the other hand,
forums and groups are not a place for general education.

Some of the questions you post have a short answer. Others have answers
that could fit an entire book. Short or long that does not matter, not
does always the answer as such, but the fact that you have an understanding.

For instance:

>> 15. What is the difference between index Re-org and index Rebuild?
>

In an index reorganisation, the index pages are moved around, so that a
sequential scan of the index follows the physical order of the disk. But
the pages themselves are left untouched.

When you rebuild an index, the index is reconstructed as if it was created
as a new index.

Good, now you know that and can answer the question at an interview, if
you memorise it. But the next question might be that "When would you use
one or another", and this you cannot answer without deeper understanding.

Learning takes time. It helps if you stay focused on one area, and don't
run in multiple directions. Hey, there are questions in the set I don't
know the full answer to by heart.