You have no doubt heard that with SQL Server 2008 R2 and Windows Server 2008 R2 we can now address 256 processors.
This is all good in theory – now see a video showing off some of the latest hardware from Unisys running pre-release versions of SQL Server 2008 R2. With this combination you can get a 72 hour query to execute in 25 seconds! and also your ETL loads too. Parallelise those bulk insert tasks – oh yay 🙂