Product has been added to your cart.

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 Mastering Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

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 Mastering Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.