This feature of SQL Server 2005 is one of the provided Solutions for Large Tables in SQL by Microsoft. Lots of help will be available in SQL Books Online Shipped with SQL 2005 on concepts and implementation. The best part of this feature is that you can...

There are clearly a lots of advantages on going to 64-bit. Read my previous blog on advantages of 64-bit SQL Server 2005. There were few cases where they found out that the query performance was bit slower in 64-bit vs. 32-bit, but that depends on type...