January 2015

Featured Presentation

Execution Plans: The Secret to Query Tuning Success

Speaker: Jes Borland (Remote Presentation)

Summary: SQL Server will tell you exactly what steps it took to return the results of your query. By being able to read this "map", you can tell where you can improve it! This session will show you how to read execution plans, what common problems can be uncovered, and what the execution plan doesn't tell you. You'll leave this session able to go to work, open a plan, and identify where to start fine-tuning the query.

About Jes: Jes Schultz Borland is a consultant with Brent Ozar Unlimited and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is an active member of PASS, President of FoxPASS in northeast Wisconsin, founder of Tech on Tap, and a blogger. Jes frequently presents at user groups, SQLSaturdays, and other community events. She is also an avid runner and chef.

Pre-Meeting Presentation

Query Tuning Mastery: Manhandling Parallelism, 2014 Edition (Video Replay From the 2014 PASS Summit)

Speaker: Adam Machanic

Summary: 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.

Back to Top