Really Scale with SQL Server 2008 R2
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 :)