april, 2020
Abstract
Abstract
As part of the SQL Server Internals Group, Uwe Ricken (Microsoft Certified Master, MVP), will hold an online session on user-defined functions from SQL Server 2000 to SQL Server 2019.
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.
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.
Speaker for this event
-
Uwe Ricken
Uwe Ricken
MCM, MVP
Uwe Ricken has been working with IT systems since the 1990s. After 14 years as a developer of complex database models, he received the "Microsoft Certified Master - SQL Server 2008" certification in May 2013, which was Microsoft's highest technical certification. In 2013 he was honored as an MVP for his outstanding support of the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker at many international conferences and events as well as preferred topics for "Database Internals", "Indexing" and "Development".
MCM, MVP