July 2010 PASS Performance VC Presentation
Performance Impacts Related to Different Function Types
July 6th 12:00 PM EDT (GMT -4)
Presenter: Jason Strate
Abstract:
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
Goals:
§ Identify purposes for creating user defined functions
§ Discuss the types of user-defined functions
§ Demonstrate performance impact in selecting different types of functions
About Jason:
Jason Strate, Digineer Inc, is a database architect and administrator with over twelve years of experience. In July 2009, he was awarded Microsoft MVP (Most Valuable Professional) for SQL Server. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. He is actively involved with the local PASS chapter (SQL Server User Group) and is currently serving as the Director of Program Development. In the past year, Jason has presented at the 2009 PASS Summit, SSWUG Virtual Conferences, TechFuse 2009/2010, SQL Saturdays, and at PASSMN user group meetings.
Attendee URL: https://www.livemeeting.com/cc/usergroups/join?id=3CF2HR&role=attend&pw=S%60w-%7E7%5C6b
