User-defined functions in SQL Server 2008 by Steve Kass
User-defined functions were a new feature in SQL Server 2000, and both
major versions of SQL Server since 2000 have added enhancements and
improvements in the area of user-defined functions.
We'll look at some new features in SQL Server 2008 that enhance and
improve what user-defined functions can offer. We'll also look at some aspects
of user-defined functions (relevant to SQL Server 2000 and 2005 as
well) that deserve wider understanding, particularly with regard to how they
affect performance.
Speaker: Steve Kass is Professor of Mathematics and Computer Science at
Drew University in Madison, NJ. He is a co-author, with Itzik Ben-Gan,
Dejan Sarka, and Lubor Kollar, of Inside SQL Server 2008: T-SQL
Querying, published last month, and he is the technical reviewer for
Inside SQL Server 2008: T-SQL Programming, to appear later this year. He
has been a Microsoft SQL Server MVP since 2002.