Description:
In this video, I delve into scalar UDFs (User Defined Functions) in T-SQL, discussing their potential pitfalls and how they can impact query performance. We explore the differences between non-inlinable scalar UDFs and those that are eligible for inlining, using examples from my Learn T-SQL course to illustrate these concepts. I also share some practical tips on when and how to rewrite scalar UDFs as inline table-valued functions to optimize your queries further. If you're interested in learning more or want to support the content, check out the links in the video description for training opportunities and ways to engage with me directly.
CHAPTERS
00:00:00 - Introduction
00:02:15 - Scalar UDFs Overview
00:04:08 - Scalar UDF Inlining Restrictions
00:06:39 - Non-Inlinable UDF Execution Plan
00:08:45 - Performance Impact of UDFs
━━━━━━━━━━━━━━━━━━━━━━━━━━
???? TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY
SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING
Learn T-SQL with Erik
https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL
Everything Bundle:
https://training.erikdarling.com/?coupon=SPRINGCLEANING
━━━━━━━━━━━━━━━━━━━━━━━━━━
????️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlconsulting
━━━━━━━━━━━━━━━━━━━━━━━━━━
???? CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/
Become a channel member
https://www.youtube.com/@ErikDarlingData/join
━━━━━━━━━━━━━━━━━━━━━━━━━━
Share this link via
Or copy link