A Few of My Favourite Query Plan Operators
Query plan operators are where the work is done when you run a query. Some operators are more significant than others. You might have learned about Seeks and Lookups and about different Join operators, but certain operators convey a lot more information than you might realize. This session looks at operators such as Merge Join (Concat), Top N Sort, Filter, Hash Match (Flow Distinct), and more. Explore the significance of some of their properties, and raise your game when it comes to performance tuning.
About the Presenter
Rob Farley runs LobsterPot Solutions. He is an MCM, MVP, MCT, PDW Trainer, and proud Arsenal supporter. He spends a lot of his time either tuning queries or helping people with their BI systems, from small in-house data warehouses to large PDW implementations. His presentation style and his insight into the complex made simple and profound make him unique in the SQL Server community, with or without his guitar. He blogs at http://sqlblog.com/blogs/rob_farley and is on Twitter at @rob_farley.
This event is hosted by the Adelaide SQL Server User Group, and sponsored by LobsterPot Solutions
Join millions of people on Eventbrite.
In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.