Wednesday, August 3, 2016
Performance Pitfalls from Code Reuse – Andy Yun
Abstract: Have you 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 come at a significant penalty?
Come to this session and learn why applying object-oriented principles can be extremely detrimental to your T-SQL's performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to see how it handles these scenarios. Through extensive demos, we will explore solutions to maximize performance. You will be introduced to a T-SQL tool that will aid you in unraveling nested code. Alternate design patterns will be shown to help you mitigate these performance pitfalls.
Speaker Bio: Andy is a Database Developer & Administrator with Ensono, LLC, an IT Managed Services firm. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, Andy strives to make T-SQL leaner and meaner. Passionate about passing his knowledge onto others, Andy actively participates in the SQL Server community, as co-Chapter Leader of the Chicago Suburban User Group, and by speaking at regional User Groups & SQL Saturdays.
We meet at Omni Resources, 4351 W College Ave, Appleton WI 54914. This is the Concordia University building just west of Hwy 41.