Hints and Parameters Support for table, join, and query hints inside natively compiled, scalar user-defined functions is equal to support for these hints for natively compiled stored procedures. As ...

The scalar UDF inlining feature improves performance of queries that invoke scalar UDFs in SQL Server 2019 and later versions. Scalar UDFs typically end up performing poorly due to the following ...

In SQL Server 2014 we saw the introduction of Natively Compiled Stored Procedures. In 2016 we’ll be able to do the same for Scalar User Defined Functions.