Brent Ozar 4.83
If execution plans look like subway maps of foreign cities, this session is for you. Brent will turn SQL Server inside out by making YOU role-play as the SQL Server engine. He’ll feed you one query at a time, make you write your own execution plans in plain English, and then show how SQL Server draws out execution plans. You’ll learn how sorts and joins rely on indexes, and get your first glimpse into why statistics are so important. No tuning experience necessary, but you do need to understand how to write SELECT statements with joins.