SQL-Server-Regex gives you the power to run regular expressions inside SQL Server queries. It works by using SQL CLR functions to call the C# System.Text.RegularExpressions library. The RegexMatch() ...

Learn the differences between scalar and table-valued functions in T-SQL and how to use them for better query performance and readability.

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

Function inlining in SQL Server 2019 Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. This means they will be folded into the query and no longer incur the UDF ...

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

We demonstrate the benefits of Froid including performance gains of up to multiple orders of magnitude on real workloads. Froid is available as a feature of Microsoft SQL Server 2019 called ‘Scalar ...