Rich - no not directed at you - there's an almost constant number of posts over memory on sql server, I don't think there's a definitive description posted anywhere. Giving...

sorry but you're still missing the point, the /PAE switch has nothing to do with a page file .. don't understand this question.  As I keep trying to point out,...

Hmm . I'll have to get back to you, I used a production database on a test server. my selects used a sarg of   " where col1 = @variable "

I...

I'm working with an app that was designed by developers who are a pretty skilled bunch of guys and who know T-SQL, however their schema leaves a lot to be...

You can use under 4gb of ram with awe OR the 3Gb switch. AND you can use the 3gb switch and awe with more than 4gb of ram.

Up to 16gb...

actually with R2 Enterprise it's now 64Gb

so being an antisocial miserable git is fine for a DBA then ?  phew - thank goodness, thought i was in the wrong job < grin >

I must be honest...

I fail to see the relevence of this question. As your table is presumably a heap it will do a table scan which would be sequential , no other way...

which edition of sql server and o/s are you using - just in case it's developer which is connection limited.

Are you certain your connections are correct as this sounds like...

have you tried searching for the file? It may have been deleted. I'm not sure that you can provide an uninstall file if one is not there.

you'd really have to post the code for anyone to help -- but --- to resolve proc issues I normally lift the code into QA and run it manually, that...

actually sql server deals with this situation quite well, I've encountered some log shipping scenarios where logs were being shipped every minute but the jobs actually took 4 mins to...

Apparently you can do this, I wasn't too sure as I know it was discussed during the 2005 workshops at ms I attended, anyway here is a link with info...

It seems to me there's plenty of documentation about mirroring and log shipping. To be honest there's not much similarity and each has its advantages and disavantages. Full mirroring really...

memory available is limited by the underlying o/s, there's too many posts about this .. this link shows capcities for windows 2003

http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx

To use the extra memory you'll need the...