The problem is (and i have come across this before) if you do point out a dev's bad piece of code mostly they get uptight, jumpy and defensive instead...

Paul

what Jeff is saying (and you have to agree is quite correct),You shouldnt do it expecting a massive increase in performance otherwise you could well be dis appointed. There are...

if its a VM and you have the OS licence, may as well install 64 bit. As a VM you can scale memory, cpu and disk when required

here you go, courtesy of uncle Bill

http://www.microsoft.com/downloads/details.aspx?familyid=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en

what version vmware server you using?

have you mapped your VM's virtual NIC to the physical network or to a private virtual network, double check your config

you didnt get the job then?

full filegroup backup is different to full database backup

Ryan Wellman (5/16/2007)

---

Sweet!

I changed the "log on as" to .\Administrator for SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER). In the SQL Server Configuration Manager and ran the Log...

the application will generally just issue statements to the database. What can cause problems is 32 bit versions of sql server interracting with 64 bit versions, replication in particular is...

Dave (3/10/2009)

---

I am trying to locate some sort of information to present to my managers regarding whether there is any differences, between 32Bit and 64Bit, in the way SQL Server...

if the server login exists and the database user exists in the database you only need to use

exec sp_change_users_login 'Update_One', 'Current user in DB', 'SQL login to link to'

xgcmcbain (3/11/2009)

---

2) by limiting my ram, am i hurting my server in anyway? Now remember, in my environment none of my select statments are redundant so cachine a queiry...

queries are only a small part of what sits in RAM, you have the buffer pool too which comprises all the database pages read from disk to memory for modifying....

hey, your welcome buddy 😉

i think the windows registry would be the best place to look

try running it once a week during a known period of low or no activity!!