The short answer is try it, test it. If it works/helps good  if not forget it!!

I've sometimes made gains by making the bit column part of another index. I often encounter tables which have a column to designate current or active data. Every query always...

and congrats on mvp. The database chaining caught a few of us out on sp4 where we had some common code within master - suddenly it stopped working!!!

ah no you can't change an instance to a default - you'd have to run another install.

remove sql2k with remove programs.

sorry - yes implemented last three clients but not current, will check my own servers tonight.

I'd think that if the agent service was running a batch of commands then...

Your approach should be based on how much data is ion the table:

For a smallish table just take the table out of replication, make the changes, add it back and...

sql2k and sql2005 can exist quite happily side by side, they install as seperate installs and can be instances if you wish. One is never an instance of the other,...

sorry I was going to add, you have to license the o/s that sql server runs on, you always have, it's never come free, ever. I don't see what the...

It's normally easiest to license by processor, then you don't need cals. You can't cal an internet app, that's what proc licenses are for.

sounds to me like you're all...

sounds unrelated to me although the agent memory seems a tad high. How are you measuring this value?

yup you're mixing cals and procs, note that you don't really gain much by putting sql std on ent w2k3 unless you're 64bit or running a non dedicated sql server.

I'm...

been there done that, that's why I've finally posted. I'm pretty sure it's down to group policy but like most things you have to be able to prove it. Most...

sorry - wrong key!!

• Triggers - guaranteed to cause problems
• Dynamic sql
• embedded sql
• implicit transactions poorly formed
• temp tables within transactions
• stored proc recompilation - procs starting sp_
• linked sevrer queries
• cross database queries
• insufficient server resource -...

readers block writers and slow system makes transactions slower thus increasing blocking.

Quick fix = add more memory as this will cache more data thus making transactions quicker ( reduces disk...

readers block writers and slow system makes transactions slower thus increasing blocking.

Quick fix = add more memory as this will cache more data thus making transactions quicker ( reduces disk...