2.2 User-Defined Functions

Scalar UDFs, multi-statement table-valued functions, and inline functions: only the last one performs well. Brent demos all 3, shows you how they hide in execution plans, and explains how SQL Server 2019 helps. Demo Script Transact-SQL /* Mastering Query Tuning – Why 2 Out of 3 Functions Don’t Scale This script is from our Mastering…

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.