I sometimes worry that here we are 7 years on from SQL 2000 and we still have these endless posts about memory on SQL Server. Even more worrying is the...

If you want anything other than mediochre performance your luns for sql server should be on dedicated spindles - and certainly not share with anything, especially exchange.

fibre channel will be...

It's probably what I'd expect, can't comment on Oracle - you'd need to examine the process to figure out the locking to avoid this issue - you could try the...

yeah - very simply a "covered" index contains all the data required by the query so that the index satisfies the query without reference to the table. Covered indexes work...

what do you hope to achieve and prove? The whole point about testing is that you must have  a result in mind.

As you've not stated the edition and o/s or...

did you run setup.sql too ?

If you're viewing from a  client the client needs updating too. 

sorry should have added:- on what basis do you imagine there could be a problem?

yes and yes

this also depends upon the size of the result set, as well as the connection speed and bandwidth, qos settings etc. etc.

If a query runs slower from a client...

in general I'd agree with you - from what basis does your "supervisor" make the conclusion the performance isn't fast enough?

I'd suggest that to find a way to optimise this...

very carefully!!

get a book on dot net, or use a client application - such as an access client ( although this wouldn't be a personal recommendation ) - I guess I'd...

You will have no problems from the sql server point of view in any direction. dot net code compiled under 32 or 64 bit compilers will be different but the...

Do you actually have awe enabled and have you set max memory ?

• NB. enabling awe memory DISABLES dynamic memory so with awe on all the memory will be taken at...

an answer no would have probably been better than a link, however, views cannot take the maxdop hint, I sometimes wish they did because I've encountered some quite appalling views...