You’re confident writing queries to get the data you want, and you’ve been doing it for a couple of years. You’ve taken our free T-SQL Level Up class, mastered tally tables and windowing functions, but what else is there?
In this class with T-SQL maestro Erik Darling, you’ll learn tricks to take your queries to the next level: dynamic SQL, CTEs, fast-performing functions, temp tables versus table variables, computed columns, and more.
The first three modules are available now for our Performance Tuning subscribers:
- Dynamic SQL (36min) – you already know that it’s a powerful technique involving building strings and executing them. In this session, you’ll learn how sp_executesql isn’t just more secure than EXEC, but it can be faster, too.
- Common Table Expressions (CTEs) (20m) – they look kinda like subqueries, but they have big differences in how they perform. The good news is that they give you more readable queries with separate optimization pathways, and they can pull off tricks like filtering windowing function results and materializing hierarchies. The bad news – well, let’s get into the details.
- Computed Columns (39m) – as we discussed in level 1, they’re great for frequently calculated items when you want to reduce CPU overhead, plus index and filter on repeatable computations. However, there are some performance and filtering drawbacks, so we’re going deeper.
Modules on filtered indexes, functions, key lookups, parallelism, sargability, temp tables vs table variables, and more will be coming out over the next few weeks.
Wanna get in on the learning action? This is the last week to use coupon code Relaunch2017 to sign up for our new subscription plans.