I’ll be speaking for the SQL PASS Performance Virtual Chapter later today starting at 12 PM Eastern time. The topic will be Performance Impacts Related to Different Function Types. The abstract for the event is the following:
User defined functions provide a means to encapsulate business logic in the database tier. Often the purpose of the encapsulation is to provide standard method access segments of data within the database. Unfortunately, not all methods of creating user defined functions are equal. In this session we’ll review the types of user defined functions and investigate the performance impact in selecting the different types
- Identify purposes for creating user defined functions
- Discuss the types of user-defined functions
- Demonstrate performance impact in selecting different types of functions
You can get to the event here.