DiscoverChannel 9SQL Server 2019 Improves Scalar UDF Performance | Data Exposed
SQL Server 2019 Improves Scalar UDF Performance | Data Exposed

SQL Server 2019 Improves Scalar UDF Performance | Data Exposed

Update: 2020-08-11
Share

Description

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.
 
[01:10 ] What are UDFs?
[01:47 ] Performance Issues
[02:30 ] UDF Scalar Inlining
[03:15 ] Demos
[11:40 ] Control when inling is used
 
 
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:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real-world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram
Comments 
In Channel
loading
Download from Google Play
Download from App Store
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

SQL Server 2019 Improves Scalar UDF Performance | Data Exposed

SQL Server 2019 Improves Scalar UDF Performance | Data Exposed

Anna Hoffman, Marisa Brasile