Eric Hanson, principal program manager for SQL Server data warehousing, walks through several of the key features and functions of SQL Server 2008.
Make the most of your available hardware resources through intelligent parallel processing against partitioned tables. SQL Server automatically assigns queries to all available threads. All cores share the workload equally to scan qualifying partitions, process and deliver results.
If you're having difficulty reading the scripts, please select a higher-res format for viewing.