Fix 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.
Tag: scalar-functions
Find the Scalar Function Call: What It Means When It Hides in Probe Residual
Category:
query-performance
User defined functions are fairly simple to create in SQL Server, but figuring out exactly how they are being used can take a little time - even in a simple execution plan. This is because the functions can be tucked away into lots of different operators in the plan, even join operators.
The good news: once you learn what to look for, it’s not terribly complicated. There are some fancy terms involved, but the definitions are pretty simple.
Why Is My Function Missing From sys.dm_exec_query_stats and Query Store?
I just spent 90 minutes of my life figuring out a detail about sys.dm_exec_query_stats which I’m pretty sure I figured out five years ago, but didn’t write a blog post about.
Time to write a blog post, so I can save time when I go searching for this in a couple years.