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.
9 Comments. Leave new
Nice Erik!
I have an Enterprise subscription and I can’t access the course modules, since Enterprise includes performance tuners I guess this should be included, right?
Yep! Make sure you’re signed in, and if that doesn’t work, shoot us an email with your login and a screenshot. Thanks!
Update: Only the “Dynamic SQL” module isn’t accessibile saying that:
“To access this incredible, amazing content, you gotta get Performance Tuning Class (Live, 4 Days), or log in if you already shelled out the cash.”
You swapped the requirements for the Performance Tuning online course with the Performance Tuning Live Class 🙂
Ah! There we go, fixed. Enjoy the class!
Still not accessibile with the same message after clearing out the browser cache, maybe check the cache on your side 🙂
Working fine here – but can you do me a favor and *send screenshots* as I asked for earlier? I really appreciate the help. Thanks!
Now it works fine, it was just a matter of waiting, thanks again!
Awesome!
Brent and Co. We (by we I mean the company) paid for an 18 month Everything bundle last November. Will we get the new content too? Or do we just get access to what was included in that bundle at that time?