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.
1 post, 19 Comments
Hugo Kornelis is an established SQL Server communiity expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He is a SQL Server MVP since 2006. When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has over 18 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.