But prior to the upcoming 2019 release, SQL Server’s support for scalar functions was fraught with problems. In SQL Server, a function that returns a single value is known as a “scalar UDF ...

As I recall, the scalar function inlining query optimization improvement, made it to GA in SQL Server 2019 before it made it to Azure SQL DB. However, a couple of exceptions aside, looking to the ...

Sadly, this has been a problematic design pattern in SQL Server. The scalar functions are executed in a black box, giving no insight into the underlying query operations to process them and ...