Unanswered: SQL Server 2005 and 32-bit versus 64-bit
we are about to purchase new database servers and have been offered a good deal on 64-bit Xeon machines. At present we run SQL 2000 on Windows Server 2003 both of which are 32-bit versions.
Is there any problem using our current 32-bit Server software on the 64-bit machines (apart from not being able to utilise its full power)? I'm assuming the SQL 2005 licenses are the same price regardless of 32-bit or 64-bit version. If we buy a 64-bit SQL Server version license are we going to get the best out of it on a 32-bit Windows Server edition?
32 bit software will work on a 64 bit hardware platform (I have it running here as well). The other way around will probably not work because you need to have a 64 bit OS for running 64 bit software. And as far as I know, the 64 bit OS does not run on a 32 bit hardware platform.
> SELECT * FROM users WHERE clue > 0;
Empty set (0.00 sec)