Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)

Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)

By Kendra Little
1 min read
Category: tsql-programming , sql-server
Tags: user-defined-functions , udf , scalar-functions , table-valued-functions , sql-server-2019 , udf-inlining , pass-summit
Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video) 1 min read
Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)

Last week, I presented on the topic of TSQL User Defined Functions (UDFs) in SQL Server at the PASS Summit.

Video (1 hour 10 minutes)

🔥 Scalar UDF inlining: If you're just here to see the SQL Server 2019 (CTP2.1+) scalar UDF inlining, that starts 54 minutes into the video.

RELATED POSTS

Bad News, DBAs, We Are All Developers Now

Bad News, DBAs, We Are All Developers Now

I sometimes joke that I’m a Junior Developer and a Principal Database Administrator, which is why I have a Staff level title. I’m not sure …

Read More
Adaptive Joins and Memory Grants in SQL Server

Adaptive Joins and Memory Grants in SQL Server

Adaptive joins let the optimizer choose between a Hash Join and a Nested Loop join at runtime, which can be fantastic for performance when row count …

Read More
Carrying Baggage Through Query Plans: Why Wide Queries Get Heavy

Carrying Baggage Through Query Plans: Why Wide Queries Get Heavy

I see this pattern repeatedly: a “wide” query that returns many columns and less than 100k rows runs slowly. SQL Server gets slow when it …

Read More