Query Tuning Mastery: Manhandling Parallelism, 2014 Edition [AD-400]

Adam Machanic
75 minutes
Application & Database Development
When it comes to driving ultimate performance for your biggest queries, parallelism is the name of the game. Don't let SQL Server decide when and where to apply its parallel magic; be your own query optimizer and take control! The 2012 edition of this talk--one of the most popular sessions at PASS Summit--discussed problems with parallel costing, intricacies of plan selection and execution, and the extremely effective Parallel CROSS APPLY pattern. But these things were just the beginning. Two more years of research have yielded new insights, new techniques, and new performance gains. In this session, you'll get a quick review of the 2012 content before diving into brand-new costing hacks, tricks for leveraging parallel scans, and a set of SQLCLR functions that will give you more control over intraquery parallelism than you ever thought possible. Get ready: it's time to Manhandle Parallelism all over again.
Three to five years of SQL Server development or hands-on DBA work.

Accompanying Material

No material found.