Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let’s look into the performance gains this offers.
(2017-2022)
Browsing Posts tagged Performance
SQL Server 2019 introduces Scalar UDF Inlining, which is supposed to improve the performance of Scalar UDFs. This post investigates this new feature.
One of the things that I’m the most excited about in “Denali” CTP3 is the enhancements to the OVER clause. One of the things that I’m particularly excited about is the addition of the ROWS/RANGE clause support. One of the reasons that I’m excited about this is that this provides a supported, documented (in BOL) […]
