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 on • 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

How to See Rowcounts and Execution Time for In-Flight Queries in SQL Server

How to See Rowcounts and Execution Time for In-Flight Queries in SQL Server

I frequently need to see rowcounts and execution time for queries while they’re running. Maybe I’m troubleshooting a slow query …

Read More
Three Reasons RDS SQL Server Is Better Than Azure SQL Managed Instance

Three Reasons RDS SQL Server Is Better Than Azure SQL Managed Instance

While every managed database service has high points and low points, there are three things that make RDS for SQL Server shine in comparison to Azure …

Read More
Fixing OPTIMIZATION REPLAY FAILED in Query Store: When Plan Forcing Breaks in SQL Server 2022+

Fixing OPTIMIZATION REPLAY FAILED in Query Store: When Plan Forcing Breaks in SQL Server 2022+

Forcing plans with Query Store can be a powerful tool— until it mysteriously fails. In real production systems, plan forcing sometimes just… doesn’t …

Read More