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 ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. One first-time track host shares the process, ...

For the past several months we’ve been talking about the advances in SQL Server 2016. Now, at last, the wait is over. SQL Server 2016 is now generally available and brings with it a feature set ...

Abstract: XML is often used to represent objects that expose different sets of properties. This "property bag" scenario is a prominent use case for the XML support added to Microsoft SQL Server 2005.