all to do with the i/o per second throughput and bandwidth. If you've trended the performance on tempdb you'll know how many soindles you'll need at each raid to match...

no you're not missing anything - it's basically rubbish! You can use an eval of sql2005 to run the tuning advisor then transfer the information back to sql2k. I don't...

raid 1 and raid 10 are the same except raid 10 uses more disk pairs. for each additonal pair the performance gain is linear, or doubles the original pair. Many...

agreed, no worries,  can do this every time.

you could use a replication snaphot. or script them and do a find and replace. or change the owner using the provided sp_sproc

think you'll find the number is the object id ?   ( but i'm not 100% ) I always use server trace flags to resolve deadlocks - creates enormous logs but...

Your other option is not to send data at all but publish at a central location and run the queries through a browser, that way you never have to move...

Well to be honest I'd lay my hands on an eval of sql diagnostic manager and point it at my server. I think by the time you've gone through all...

Rudy - I totally agree! I normally work within controlled production environments where the use of the GUI is an absolute no-no. You'll never get SOX using the GUI !!!...

alistair - sorry for delay have responded!

you could probably do it through the GUI but it's not an auditable process within a controlled production environment so no use to me...

Discussion is good - what I feel is that too many posts are not making any attempts to research first, so many answers are found in BOL and some investment...

There are some serious errors and misconceptions and this is only going to add to more users messing with options they don't understand!.

Procs, the number are doubled under w2k3 and...

It's a matter of scale and design. What's a user logically going to do with 2 million rows/ 800mb data from a query? read them all? You also mentioned "ad-hoc"...

Philip -  a covered non clustered index takes it's selectivity based upon the first column, should this column not be as selective as it could be, or becomes that way,...

If cpu >80% then you have problems - the quickest upgrade is to make memory > = database size , you may have thread starvation which would be right considering...