I'd suggest a training course - if you're really hosting a sql server this way you shouldn't be asking this question. I know this sounds harsh but data security is...

yes and no.

you can certainly search stored procedure text and there's lots of code and discussion on this point, it can be tricky(ier ) where procs are very large and...

perhaps you could expand your question a little as I'm not quite sure what you're asking, sorry.

I'd just add anothe point having come from supporting an ERP system which used dynamic sql, sql 2005 doesn't seem to handle ad-hoc type queries half as well as sql...

I'd look for another job - you can never really get any performance out of apps like this and once you've exhausted the hardware options you've nowhere to go. Your...

there are numerous ways to check server memory I've never bothered with this counter - run this query and see what you get

use master

go

select counter_name ,cntr_value,cast((cntr_value/1024.0)/1024.0 as numeric(8,2)) as Gb...

in as much as I've applied CU5 to both x64 and x32 servers and have previously deployed x64 and x32 versions of same patches, yes they are the same

however I...

it depends exactly what it is you're looking for. The microsoft blogs are probably your best bet although 2005 is starting to be old stuff now. the sql cat team...

waiting for something to happen? twiddling my fingers until someone does something. catching forty winks until I'm asked to do something.

awe is not allocated dynamically, setting awe on a x32 server disables dynamic memory management and sql server will take all the memory up to the max memory setting. a...

reported by both the dmvs and diagnostic manager.

you can see the report I use on this page http://www.grumpyolddba.co.uk/monitoring/Creating%20Custom%20Reports%20for%20the%20DBA.htm

ok so I didn't word that correctly - each user runs the application across the network from their workstation and the server the app is on is also the...

x32 only uses awe. you must have the /pae switch set in boot.ini. you must set awe option on, you must set max memory. min memory is ignored with awe,...

are you saying your users are launching the app from a shortcut on the server ?

If so I can't see how that would work.

you should only consider x64, there's little point in using 32 bit apps with all the memory issues and limitations. x64 std sql takes the memory limit of the o/s...