Announcing Erik’s First Video Class: T-SQL Level Up, Level 2

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.

Explaining computed columns with the Stack Overflow database

The first three modules are available now for our Performance Tuning subscribers:

  1. 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.
  2. 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.
  3. 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.

Previous Post
[Video] Office Hours 2017/04/19 (With Transcriptions)
Next Post
Hold The FiIter: Startup Expression Predicates

9 Comments. Leave new

  • Emanuele Meazzo
    April 25, 2017 8:23 am

    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?

    Reply
    • Yep! Make sure you’re signed in, and if that doesn’t work, shoot us an email with your login and a screenshot. Thanks!

      Reply
    • Emanuele Meazzo
      April 25, 2017 8:29 am

      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 🙂

      Reply
  • Awesome!

    Reply
  • Jon Szewczak
    April 26, 2017 2:23 pm

    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?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}