Thank you to our sponsors




All 24 Hours of PASS registrants will automatically become PASS members. (membership is free!)





High-Performance Functions

Return to Session Listings

Presenter: Simon Sabin, SQLKnowHow

Session 12 (23:00 GMT on May 19)

Session Details

Functions, which you use to encapsulate common code, are a valuable development tool. This session looks at how you can write functions in SQL Server and then explores the performance differences of using functions. After this session, you will understand how you can increase your query performance 100 fold just by employing some simple best practices.


About the Speaker

Simon Sabin is the principal consultant for SQLKnowHow, a company specializing in SQL Server consulting and training. He has worked with SQL Server since 1998, focusing on reliable, high-performance systems, and has particular expertise in search, distributed architectures, business intelligence, application development, and making Web sites and applications run faster through scale-out technologies and database performance tuning. Simon, who was named a SQL Server MVP in 2006, runs user groups in London and Cambridge ( and in 2007 founded the SQL Bits ( SQL Server conference in Europe. He is a regular speaker at SQL Server events and blogs at


Register now for 24 Hours of PASS!



Check out the speaker lineup!



Copyright 2013 by PASS | Terms Of Use | Privacy Statement | Login