[newbie] dbcc showcontig

Hello.

Can you point me to books or good documentation that could help me in
understanding in detail the dbcc showcontig output (and the output of
other command that analize the status of a DB) and permit me
understanding what is going on and taking appropriate action?

Do you think a Microsoft Courses could help in this, or is it necessary
to just study/work to become good in this? If it can be useful, which
Microsoft courses?

Best Regards,
Mamo<mamo74@.gmail.com> wrote in message
news:1106796688.136298.283920@.z14g2000cwz.googlegr oups.com...
> Hello.
> Can you point me to books or good documentation that could help me in
> understanding in detail the dbcc showcontig output (and the output of
> other command that analize the status of a DB) and permit me
> understanding what is going on and taking appropriate action?
> Do you think a Microsoft Courses could help in this, or is it necessary
> to just study/work to become good in this? If it can be useful, which
> Microsoft courses?
> Best Regards,
> Mamo

http://www.sql-server-performance.c..._showcontig.asp

Simon|||This is a good guide but leaves out a huge amount of relevant information
(most significantly a discussion of logical fragmentation, DBCC INDEXDEFRAG
and the effects of multiple files on the DBCC SHOWCONTIG algorithms). You
should also read our whitepaper on the subject (it also deals with when you
should bother to reduce fragmentation).

http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx

Regards

--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:41f8cfb0_2@.news.bluewin.ch...
> <mamo74@.gmail.com> wrote in message
> news:1106796688.136298.283920@.z14g2000cwz.googlegr oups.com...
> > Hello.
> > Can you point me to books or good documentation that could help me in
> > understanding in detail the dbcc showcontig output (and the output of
> > other command that analize the status of a DB) and permit me
> > understanding what is going on and taking appropriate action?
> > Do you think a Microsoft Courses could help in this, or is it necessary
> > to just study/work to become good in this? If it can be useful, which
> > Microsoft courses?
> > Best Regards,
> > Mamo
> http://www.sql-server-performance.c..._showcontig.asp
> Simon

[F4] properties dialog does not follow convention of defaultvalue <> bold, changedvalue=bo

Just thought I'd point it out as something that needs fixing. This is inconsistent with every other MS product using the VS.net IDE framework.

I'd post it on Connect but then I'd wait 2 months to get "won't fix - this does not 'fit' with the current Katmai schedule" i.e. if I'm lucky (based on the new improved 3yr delivery of sql) it might get delivered in 2011. Wow.

Imagine if Xbox or PS3 designers told their customers, "sorry we know that up/down/left/right are in fact right/left/down/up, as you may expect on a game controller, but if you wait 3 years we might fix it"

I'm tired of your attitude regarding Connect. That is the means we have in place right now. Submit the Connect bug and move on. At least then it is flagged.|||
Adolf,

I would suggest to open a a report in connect and to place the link in this thread; that way others can add their vote if they want. I agree on something, requests at connect sometimes do not get the attention we would want, but you always have the opportunity of replying back.|||

Rafael Salas wrote:

Adolf,

I would suggest to open a a report in connect and to place the link in this thread; that way others can add their vote if they want. I agree on something, requests at connect sometimes do not get the attention we would want, but you always have the opportunity of replying back.

And at least there is an official record of the bug. That is the most important part.

[EXTREMELY URGENT] sp_attach_db error

I am attaching a database with 3 data files.
When I execute "exe sp_attache_db..." I obtain this error:
database 'POINT' cannot be opened because some of the files could not be
activated.
I have deleted its LDF file.
Usually I detach my db, then I delete transaction log, and reattach 3 data
files...
Now it doesn'work!!!!!!!!!!
Someone can help me?
Thanks."George" <giorgio.benedettiNOSPAM@.libero.it> wrote in message
news:bovm8o$8o0$1@.newsreader.mailgate.org...
> I am attaching a database with 3 data files.
> When I execute "exe sp_attache_db..." I obtain this error:
> database 'POINT' cannot be opened because some of the files could not be
> activated.
> I have deleted its LDF file.
> Usually I detach my db, then I delete transaction log, and reattach 3 data
> files...
> Now it doesn'work!!!!!!!!!!

First, it should be noted in case you're not aware that deleting the LDF
file is a VERY bad idea. It should only be done in the most rare of cases.

I"m actually surprised that sp_attach_db has worked at all w/o the log file.

However, you can try sp_attach_singlefile_db, but I doubt it will work.

You'll probably have to call Microsoft on this.

> Someone can help me?
> Thanks.