But prior to the upcoming 2019 release, SQL Server’s support for scalar functions was fraught with ... it was clear it would be faster to only execute it once for each unique value.