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 MoreFix My Functions: Speeding Up Scalar and Table Valued UDFs (video)
Category:
tsql-programming
, sql-server
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
