Microsoft added several features to SQL Server 2019 that can improve performance without changes to code.
One of these is T-SQL Scalar UDF Inlining.
The use of UDFs is a red flag when tuning queries, but, in some cases, the engine will treat these as if the underlining code was added directly to the select statement.
Tune in to this session with Kathi Kellenberger to see when this new feature will help, and, more importantly, when it won’t.
- 0:00 Introduction
- 1:10 What are UDFs?
- 1:47 Performance Issues
- 2:30 UDF Scalar Inlining
- 3:15 Demos
- 11:40 Control when inling is used