PreCon: Mastering Query Tuning - Brent Ozar

***** Register here: https://sqlsatjax.eventbrite.com/?aff=Meetup *****

You’ve been working with SQL Server for a few years, and you’re comfortable writing queries and reading execution plans.

In this 1-day session, Brent Ozar will use the same practical before-and-after techniques that he uses in his Query Challenges blog series in order to demonstrate what parts of your skills need to change as you modernize your databases.

You should be comfortable using SSMS to write multi-page queries, functions, and stored procedures. You should be comfortable identifying common query plan operators like index seeks & scans, key lookups, sorts, and parallelism, and comparing plans.

In this session, you’ll:

* Learn the difference between early and late estimation errors
* Learn how to choose between temp tables, CTEs, and table variables
* Learn the best query hints to apply quickly
* And more!