A deterministic function is guaranteed to always return the same value for a given set of parameters ... SQL Server never fully integrated scalar UDF support into its execution plan generator.