1.3 CTEs, Temp Tables, and APPLY

When you’re writing and rewriting queries, sometimes you need to: Take a large query and break it up into smaller parts Make components easier to read and more reusable Join data to itself for recursive hierarchies Take the contents of user-defined functions and inline them into a query Write things to disk to repeatedly reuse…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM or Mastering Query Tuning, or log in if you already shelled out the cash.