In SQL Server, a function that returns a single value is known as a “scalar UDF” or ... a researcher for Microsoft, this scalar function can cause a query that normally takes 1.6 seconds to ...