Have you ever wondered how the SQL Server query processor really works?  Or how to read a query plan?  Or what the real difference is between a nested loops join and hash join or between a stream aggregate and a hash aggregate?  In this talk we will cover how query processing and query execution work in SQL Server.  This talk is based on a review of the life cycle of a SQL query and a discussion on how iterators -- the basic building blocks of a query plan -- work, plus an explanation of how to read query plans.  We will also dig into some of the most important and most common operators, including scans, seeks, joins, and aggregation.

NOTE: RSVP will be required for this event!  We would like to thank our friends at Red Gate Software for making this event possible.