Quatro Enemigos
This post is really four different posts. Maybe five. The main points are:
- STRING_AGG can’t be inlined if a UDF
- Getting DISTINCT values into STRING_AGG is more obtuse than it should be
- The documentation for UDF inlining is
Category: SQL Server 2019
Rewriting Scalar UDFs For SQL Server 2019 Inlining
You May Find Yourself
SQL Server 2019 has been a bit of a roller coaster ride. In particular, UDF inlining started as I think the most interesting addition to the product. Big brain stuff, for sure.
It has been nerfed …
How SQL Server 2019 Helps You Link Queries To Missing Index Requests
Not Another Upgrade
When dm_db_missing_index_group_stats_query got documented, I was really happy. After all, this has been a peeve of mine for ages.
“Wow look at all these missing index requests. Where’d they come from?”
So this is neat! And it’s …
A Bug With Recursive UDFs When Inlined In SQL Server 2019
Enough Already
I see people do things like this fairly often with UDFs. I don’t know why. It’s almost like they read a list of best practices and decided the opposite was better.
This is a quite simplified function, but …
Temporary Object Concurrency With In-Memory tempdb Metadata
Moisty
Thanks for watching!…
Database Context Is Everything
Full Frontal
…
When Does UDF Inlining Kick In?
The Eye
UPDATE: After writing this and finding the results fishy, I reported the behavior described below in “Somewhat Surprising” and “Reciprocal?” and it was confirmed a defect in SQL Server 2019 CU8, though I haven’t tested earlier CUs to …
An Overlooked Benefit Of Batch Mode With Windowing Functions
Lavender
If you ask people who tune queries why batch mode is often much more efficient with windowing functions, they’ll tell you about the window aggregate operator.
That’s all well and good, but there’s another, often sneaky limitation of fully …