PASS logo

November 14-17

In person. In Seattle

2021 Summit video library

User Defined Functions – From SQL 2000 – SQL 2019

Uwe Ricken

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.

Get updates

Sign up to get the latest conference information, announcements and price bump reminders direct to your inbox.

Redgate will only contact you about PASS Data Community Summit and SQL Saturday, unless you separately request emails about Redgate.