I380 Corridor PASS Chapter

  Eastern Iowa's SQL Server User Group
  Cedar Rapids • Iowa City

Meeting Details

Tuesday,

July

11

Exploring Why UDFs & Nested Views Hinder the Query Optimizer

  • In-Person @ 415 12th Ave SE, Cedar Rapids, Iowa (map)
  • Tue, Jul 11 2017
    17:30 - 19:30 Central Daylight Time
  • Language: English

Featured Presentation:

Exploring Why UDFs & Nested Views Hinder the Query Optimizer

Andy Yun, Senior Solutions Engineer SentryOne

Ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions & views? Did you know that object-oriented code reuse can significantly hinder the Query Optimizer? In this session, learn how T-SQL is not like other common programming languages. We will deep dive inside the Query Optimizer to understand why applying object-oriented principles can be detrimental to your T-SQL's performance. Extensive demos will not only explore solutions to maximize performance, you will also be introduced to a T-SQL tool that will aid you in unraveling nested code.

About Andy:
Andy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for over 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.

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