Details

T-SQL User-Defined Functions, or: How to kill performance in one, easy step

Speaker: Hugo Kornelis

Duration: 60 minutes

Track: DEV

User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus?
The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance.
However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.

Accompanying Material

No material found.


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids