Andy Yun
sqlbek.wordpress.com
Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP, who has been working with SQL Server for nearly 20 years as both a DB Dev and Admin.
SQLBits 2017
Performance Pitfalls of Code Reuse
Learn how object-oriented T-SQL hurts performance.
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 with a significant penalty?
In this session, learn how T-SQL is not like other common programming languages. We will peek 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.
In this session, learn how T-SQL is not like other common programming languages. We will peek 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.