Free SQL Server Training!
Join us for the January 2015 meeting of MagicPASS, South Orlando's SQL Server User Group. Food and beverages will be served, plus we've got swag to give away!
This month we welcome SQL Server MVP Jes Borland via video conference to present Execution Plans: The Secret to Query Tuning Success.
After the meeting we'll head to the Celebration Town Tavern for more socializing. (You are responsible for your own drinks)
Make a difference in someone's career: Invite them to attend the meeting with you! (Heck, invite them to attend even if you can't make it)
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 LessThanDot.com blogger. Jes frequently presents at user groups, SQLSaturdays, and other community events. She is also an avid runner and chef.
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.