User Definied Functions (UDF) came first with SQL Server 2000. While developers welcomed the introduction of these 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 get used in queries.
Lots of improvements have been made since 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 UDFs.
Sign up to stay up to date with news, special announcements and educational content.
Redgate will only contact you about PASS Data Community Summit unless you separately request emails about Redgate.
Summit video library