Use raid 5 where you only want to read data, as a recreation of an index involves reads and writes raid 5 is poor.  I see absolutely no justification or...

I use it for the alerts, the worst performing, growth, statistics, viewing user processes - it's a very useful tool to have running. Never had to worry about changing the...

on a multi proc/core box you won't get loading across the processors unless there's enough work for the box to do, under light load most of the cores/procs will sit...

We can all spend our days posting links and showing we don't read the questions !!

Well to be honest I get as much memory as I can - if...

only a quick guess - but is surface config set correctly?

without any real idea ( but encountered similar issues ) port blocking , windows firewall, group policy - all of these can stop this.

a snapshot normally overwites the subscriber, suggest you try with a blank subscriber database. Not really enough information which is probably why no-one responded.

So did you go through the GUI...

actually dbreindex and indexdefrag are not the same thing and do not produce the same end result. Please check BOL.

An index defrag may take much longer, will generally cause far...

I think a read through ms docs on clustering would be useful. In general terms clustering only protects against server hardware failure ( excluding disks ). Clusters bring their own increased...

I've had to "cope" with Business Objects in a couple of client sites, if you want to spend lots of money on something which basically is out dated and allows...

• It's a view
• It does an outer join
• It scans which indicates less than useful indexes
• it uses not equals which will likely cause scans

You need to improve the indexes to optimse the...

I'd advise you remove all hints and test and monitor with "out of the box" setup. Then analyse how things may be improved. The biggest issue for locking is table...

As the paging is unlikely to be sql server awe may not resolve anything. The DBA always says, however, if there's memory then use it!!!  I'd certainly enable awe, but...

actually I'm pretty daft !! 64 bit doesn't use 3gb switch as it's a flat memory model.

depending what your server does the 3gb switch can cause some serious problems, typical situations are extensive use of the sysmaint.exe, dts, sp_preparexml ( may have the actual name wrong...