SQL Server 2019 Improves Scalar UDF Performance

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.

Content index:

  • 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

Frank

#DataScientist, #DataEngineer, Blogger, Vlogger, Podcaster at http://DataDriven.tv . Back @Microsoft to help customers leverage #AI Opinions mine. #武當派 fan. I blog to help you become a better data scientist/ML engineer Opinions are mine. All mine.