PASS Community Summit 2008: Program Sessions (Application Development)

User-defined functions are a nice feature for improving code reuse and lowering code maintenance burden. But what most developers do not know, they come with a cost. During this session we will look at different types of functions: scalar-valued and table-valued, both in T-SQL as well as SQLCLR, and their behavior and performance impact. We will go through real-life examples of how, why and when use of functions in your queries can backfire and cause performance problems. We will also establish some best practices for use of UDFs, based on the lessons learned.

Register Now for PASS Community Summit 2008!