SQL Server 2019 Improves Scalar UDF Performance | Data Exposed: MVP Edition

From the creator

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 ✔️ Resources: Scalar UDF Inlining: https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver15?WT.mc_id=dataexposed-c9-niner Get Your Scalar UDFs to Run Faster Without Code Changes: https://www.red-gate.com/simple-talk/sql/performance/get-your-scalar-udfs-to-run-faster-without-code-changes/?WT.mc_id=dataexposed-c9-niner About Kathi Kellenberger: Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight. About MVPs: M

Published 2020-08-11 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.