User Defined Functions – From SQL 2000 – SQL 2019 by Uwe Ricken
User Definied Functions (UDF) came first with SQL Server 2000. While developers welcomed the introduction of features, they became a DAB nightmare. This session start with the very basics of User Definied Functions (SCALAR, MULTI-LINE, INLINE) and shows the problems of functions when they gets used in queries. SQL Server 2019 came with lots of improvements have been made to speed up queries which are using UDF. The second part of the session treat the great improvements of execution of functions and show ways to reach new records in the execution of your queries with UDF.