L.A. SQL Server Professionals Group

Welcome to the Los Angeles SQL Server Professionals Group

Next Meeting

Thursday,

May

15

Powerful T-SQL Improvements that Reduce Query Complexity

  • In-Person @ 110 Westwood Plaza Los Angeles, California, United States (map)
  • 18:30 - 21:30 Pacific Daylight Time
  • Language: English

Powerful T-SQL Improvements that Reduce Query Complexity

Featured Presentation:

Powerful T-SQL Improvements that Reduce Query Complexity

Hugo Kornelis

T-SQL user-defined functions may appear to be a good tool for code encapsulation and reuse, but they can have a dramatic impact on performance. In this session, you'll see why they slow down your queries, and how you can avoid this performance hit. User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus? The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of code encapsulation and reuse, and still get good performance.

About Hugo:
Hugo is co-founder and R&D lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids