SQL Server 2019 CU11 is out! ....and again on Scalar UDF Inlining
Hi Guys, The SQL Server CU 11 is out. Looking to the Microsoft changelog there aren't great imprevements from point of view of the performance, but from what i can see there is another update on the "Scalar UDF Inlining" saga! We talked about Scalar UDF inlining here: SQL Server, boost your UDFs! Yes i really think that UDF inlining (debut with SQL Server 2019 in order to increase performance) will became an important technology but what is happened unfortunately is a little different. Due to errors, at each CU Microsoft restricted the action and the functionality of the Inlining.. For example in the CU2 inlining is blocked if the UDF references built-in views (for example . OBJECT_ID) or when aggregate functions are passed as parameters to a scalar UDF. Again if the UDF references certain intrinsic functions (for example @@ROWCOUNT. Updating to the CU4 inlining is blocked if the UDF uses XML methods or contains a SELECT with ORDER BY without a "TOP 1" and eve...