https://www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/get-your-scalar-udfs-to-run-faster-without-code-changes/
Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article, Greg Larsen explains one of the...
scalar udfsrun fasterwithout codegetchanges