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

Your AI Doesn't Need to Dig Around in Production Databases. It Needs Better Briefings.

Your AI Doesn't Need to Dig Around in Production Databases. It Needs Better Briefings.

I increasingly hear or read the advice to solve problems by querying MCP servers on production databases.

Meanwhile, I’m reading output from an …

Read More
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