In SQL Server, a function that returns a single ... END According to Karthik Ramachandra, a researcher for Microsoft, this scalar function can cause a query that normally takes 1.6 seconds to ...

Microsoft announced the general availability ... In my testing, I saw up to 10x performance improvements for queries using scalar functions in SQL Server 2019. There are number of other features ...