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, The Team Membership, Mastering Query Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.