Learn how to create and drop natively compiled, scalar user-defined functions for In-Memory OLTP in SQL Server. Native compilation improves performance. In [!INCLUDEsssql16-md], you can create and ...

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.

Optimizing Similar Scalar Subqueries for XML Processing in Microsoft SQL Server Abstract: XML is often used to represent objects that expose different sets of properties. This "property bag" scenario ...