64 bit Rocks!
I’m running SQL Server Dev Edition 64-bit and loving life.
Recently I upgraded my 8 month old Dell D620 notebook to 64-bit Vista. At the same time I swapped the 7200rpm 100Gb drive for a new 7200rpm 200Gb drive (DriveSolutions.com) and upped the Ram from 2Gb to 4Gb. I was astounded at how well Vista 64-bit found and installed all the right drivers. With Vista 32-bit I lived with several small annoyances and driver incompatibilities. From my experience, Vista 64-bit is significantly smoother and more stable than Vista-32 bit, which brings me back to a suggestion I posed to the SQL Server team during PASS.
Drop 32-bit SQL Server. Except for perhaps SQL Server Express, no one who’s upgrading to Katmai for a production server needs to run on a 32-bit server any longer. 64-bit solves so many memory issues and runs so much smoother, I’m voting for 64-bit only Katmai. Comments?