to use mapi you must install a mapi client for the account under which sql server/agent runs.

drat - fire alarm timed out my reply!!!  As far as I know the page splits counter is server wide so you can't even pin it to a database -...

Oh yes I was going to add, as you've discovered, altering the server setting doesn't make it go away ( unless you set it to 1 ) which shows it...

I expect you'll get shed loads of posts about applying maxdop on the server setup. I'd suggest you let your server use all procs - by setting the processor mask...

This is a "it depends" answer. You're not splitting the table to normalise so all you're really doing is to add an extra join into what other joins you might...

Hmm .. I sometimes wonder at the messages coming out from microsoft. Again what would you be releasing memory for? SQL will only take the 2gb from below the 4Gb...

fine if that's the case then you have a perfect process! My experience tells me this isn't the case and you can modify it to work otherwise. Obviously upgrading to...

you should be aware that a re-index may be very intensive - especially on a slow disk subsystem and/or with std edition. To be honest 80Gb is pretty small for...

tricky!!  I've usually taken a backup to another server to run diagnostics in these types of events. You can do a dbcc showcontig on a table basis - one way...

you need to establish the root cause of the slow performance and resolve that. I suspect you're probably i/o bound. I suggest you analyse the query plan for your reconcilliation...

could be lots of reasons - you really need to try to examine the plan to see what happened. The stock answer is that the underlying data changed sufficiently to...

I've always set min and max memory to be the same with awe and also checked the reserve physical memory.

I've never found awe using more memory than allocated, I can...

tricky isn't it? But do we assume everyone will upgrade to vista anyway? I'm just finishing migrating sql7 on NT out to sql2k and w2k3 ( it was nearly w2k...

Yeah it's tricky isn't it?  We have mostly Select cd/s which contain / don't require the entry of a key. Most of my technet media require keys which is fine...

As someone else noted the article was a bit old!! Replication is always difficult for GUI users but if you script then making changes to objects is a doddle. I'm...