Thanks Ted, that is good to know.

Thanks Thai, that is good to know.

Graham,

I have no particular solution for replacing outer joins.  I was suggesting more going back and analyzing the business requirements.  What questions are asked, when and why?  If you...

I posted a longer answer to this but it got lost in the ether.

So in short: One book I recommend that covers all aspects...

Here are some good questions:

1. What is the cost to have orphaned/bad data in the database?  (Of course it will never happen)?

2. How do you know what is impacted if...

Thank you homebrew01 and Mr. Dragon.

Does anyone else have experience?

Thank you Jason, I just might do that.

Ultimately both, but for the immediate term it would be the proactive monitoring to detect issues.

I will take any thoughts you have on either.

Thanks in advance.

Brian

Probably you have a run-away query.  If you can figure out which query it is, make sure it is no longer running.  (It shouldn't be.) You may need to shrink...

Thanks, Steve and Phill.

My concern with Quest on SpotLight is that they are more of a Oracle and others shop first and only recently SQL Server, but I guess I will...

I belive that agrees with what Pat posted as I would interpret (publishers/distributors first) to mean that it has to go onto those servers before the subscribers and if MS...

Well if they really loved you, or at least the work you do, they would give you one for Valentine's day.

Thanks Pat, Brian, and Steve.  I am glad to know that MS at least gets some things right some of the time.

I guess installing it will be a New Years...

Thanks, Brian.  I was afraid of that.

Steve,

What? You don't have a full fledged test system that mirrors your production system with a full set of regression tests to run?  ...