Wayne Sheffield

My blog about SQL Server

Browsing Posts tagged Performance

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.

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 particular excited about is the addition of the ROWS/RANGE clause support. And one of the reasons that I’m excited about this is that this provides a supported, documented (in […]