SQL Server 2008 Performance and Scale
Microsoft SQL Server 2008 incorporates the tools and technologies that are necessary to implement relational databases, reporting systems, and data warehouses of enterprise scale, and provides optimal performance and responsiveness. With SQL Server 2008, you can take advantage of the latest hardware technologies while scaling up your servers to support server consolidation. SQL Server 2008 also enables you to scale out your largest data solutions
Read the complete post at http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_perfandscale.mspx