DATEFROMPARTS is capable of being remoted only to SQL Server 2012 or later. Unlike other functions previously mentioned, all parameters are required, and it doesn't accept a style or culture parameter ...

the cost of caching the function parameters and results may have outstripped the benefit. However, that’s not the only problem with scalar UDFs. Another issue with scalar UDFs in SQL Server is ...