Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1486

Re: Hi Experts

Show all headers | View raw

SUBBU (nsubbu1986@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.


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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Hi Experts SUBBU <nsubbu1986@gmail.com> - 2013-05-14 22:30 -0700
  Re: Hi Experts Erland Sommarskog <esquel@sommarskog.se> - 2013-05-15 09:18 +0200
  Re: Hi Experts SUBBU <nsubbu1986@gmail.com> - 2013-05-17 23:23 -0700
    Re: Hi Experts rja.carnegie@gmail.com - 2013-05-18 04:32 -0700
    Re: Hi Experts Erland Sommarskog <esquel@sommarskog.se> - 2013-05-18 15:48 +0200

csiph-web