Thanks for the excellent comments Bob. I think it's a great idea to maybe do a parallel contest where anyone that submits a article that receives more than 200 views...

Some kind soul sent me this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_asphosting.asp

Where MS actually shows degregation in performance after a given amount of databases. There answer is actually to create a new instance...

<Soapbox>

Demico, I'm personally against doing the T-SQL programming in my shop if you're hybrid DBA. The reason for my objection is as a developer I'd hate to be...

Currently my strategy has been to consolidate our 40 or so SQL Servers onto 6 Active/Active clusters (12 total servers). It saved quite a bit of costs but this...

We just made the call for case studies this Monday. Care to work on one?

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Great Idea! I can whip up something pretty quick about that!

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

You got it. It's based on viewers.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

That would do it. Clustering is an Enterprise Edition feature only.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Should be a bit faster now. The hard drive was VERY fragmented. Whoever said Windows 2000 doesn't get fragmented was sadly mistaken.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Yeah the new web server had to my main gripe as well. Part of that though is because I'm a MS bigot. . I always...

Hi,

We're hopefully going to be migrating to a new server next month sometime which'll speed this up tremendously. Also, the first phase of the upgrade is to upgrade the...

Thanks Jay! I too am frustrated by that as I copy and paste that Active Topics area into the newsletter :). I'm working on a new release of...

Great job and it is much appreciated!

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

quote:

---

If these critical fixes are not part of SP3 then would you recommend holding off on SP3 and wait for SP4?

---