This processing is automatic and is apparent when viewing the execution plan in SQL Server Management Studio via the new Parallelism operator. Another new feature is partition elimination.