We're upgrading to SQL Server 2005 and when the Network Administrator asked us if we wanted 64bit editions of windows and SQL Server 2005 versus the 32bit versions, and there was no price difference we said sure.



However, I stumbled across an article that makes me wonder if that was a smart idea. Should I be worried? or does the 64bit edition of SQL Server just utilize the 64bit architecure for better performance while everything else (databases, stored procedures, views, etc) stay the same?

Hi Trent.

Do you mean to avoid even the 64-bit processors? It's getting hard to find the 32 bits ones.

Is it alright if I install only 32-bit applications on it?

I think we just started a new server in the wrong way here, then.

This is going to be the root of your problems.  You are better off running a 32-bit OS and any subsequent applications. 

I am saying it is best to avoid 64-bit Operating Systems...this is where you generally have all of the issues.  If you are using AMD then most of their processors support either platform.

Unless you have a specific need for a 64-bit OS and environment, you are better off going 32-bit.  Most times people think of 64-bit and assume it will be bigger, better, and faster.  This is not always the case...one thing is for sure...it will consume more resources, take longer to setup, and be a frustrating experience when loading most applications .  Don't get me wrong, there is DEFINITELY a need for a 64-bit environment, but many times it is implemented when it is not necessary.