The boot camps prove the certs are worthless .. I've even seen a MCDBA who had never used sql server. I don't know what the answer is and I agree the...

I think the node limit was removed in a sp for w2k.

The main limit for w2k is memory your active nodes would be limited to 4GB ( your inactive node...

The "Print Scrn" key works well !!

It depends if you're interested in what is in your transaction log?

If you don't need transaction log restores then make your database simple recovery and the logs will clear themselves...

thanks - appreciated

I use litespeed but I don't suppose that is much use? Does red gate offer any advantages?

Therein lies my problem - I don't know the internal configuration, it's an EMC SAN, and I'm told it's performing well - I don't agree but I need to be...

There may be a memory issue try running profiler to see if you've any queries from hell, or at least isolate the query that causes your problem.

check out ms Article...

you should script this picking up the database names from sysdatabases ( generally where dbid>4 )

Register your servers using ip address.

We tried re-naming a physical cluster , yes I know ms don't recommend it, and we had about a 50% success rate - so I...

I believe you have to use fibre channel , or so I am told, to use clustering - but I suspect this might not be the absolute case, you do...

I've met Stephen and read his article. Sadly I can't imbed a hint in the bad queries because they're dynamically generated sql from an app ( sigh ) and it...

I admit up front I'm not a lover of SAN technology, but there's very little that proves to me that DAS will not out perform even a very expensive SAN....

I have some similar issues, still not fully resolved, where a different plan is chosen for the same proc on two servers ( absolutely identical databases ) In one the...

Moving the system databases about is easy if you understand the issues involved. To put a master database from one server to another all the paths for the databases must...