Gail,

Makes sense. My doubt was a misunderstanding after all.

Perry,

Good to know about your experience. It's an interesting situation.

I'm glad to came back into this thread, so, you're welcome and I'd like to thank you all for your impressions.

It's a cool subject because CDC content isn't very wide...

Hi,

We have recently upgraded our production servers with SP3 and discovered the possible reason of long upgrade.

Our instances are using CDC enabled. CDC uses some objects used by Replication and...

Haha. That's my wish (Recoil by fire) but in my particular scenario, it's not a immediate possibility.

My main (and initial) task isn't just remove that user. It's discover the original...

We're trying to understand everything the Upgrade Script makes, including what DBCC's it uses.

Thank you anyway.

50 for each instance.

The recovery time in normal restarts is 1 minute at maximum.

Our average duration for Script Upgrade mode until I remember was around 2 hours.

Hi CKX,

I'm using SQL Server 2008 R2 EE.

Thanks for the post, I already saw it weeks ago.

My question is: logged a message that isn't not logged by default (for...

Using SP_ALTER_MESSAGE.

My test: setting is_logged_message from 1 to 0, but the message still be in ERRORLOG when certain event occurs. It's like SQL Server bypassed the change...

Maybe...

Well...if I update a logged message to 0 (aka please don't log it), then, why the message still be logged?

Very nice article, Gail.

Nice way to tell: Have a baseline of your environment and/or in troubleshooting scenarios and use a TOP X Trouble approach for the win. :hehe:

Also:

"Tuning...

Thanks Erin.

Nice article.

Simple, useful and easy to implement 😉

I have a doubt (dummy,I think so): If your production environment is using Enterprise Edition, why you don't deploy Developer Edition in DEV/HOM instead of Standard Edition?

[]'s

Great attitude from SQLSC.

Plagiarism is bad for many reasons, then, the guilty involved must be uncovered without piety.

Here is my humble and sample code using OVER(clause):

/* Brings the third...