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.

Andy Yun's previous sessions

Can SQL Server 2019 auto-magically fix my bad T-SQL code?

Come to this session to see how SQL Server 2019 mitigates two common performance killers: scalar functions and table variables!

Advanced Plan Explorer Usage for Tuning Execution Plans

Users of Plan Explorer often only utilize the basic capabilities to tune execution plans. This session will cover more advanced techniques to get the most out of SentryOne's FREE execution plan analysis tool.

Share Your Story: Developing Your First Presentation

Take an idea and learn how to develop your first session.

SentryOne Tools for Productivity and Performance

This quick vendor session demonstrates the spectrum of SentryOne's best-of-breed products for the Microsoft Data Platform, from Task Factory, to Plan Explorer, to DOC xPress, to the SentryOne monitoring platform, and beyond.

Uncovering Duplicate, Redundant, & Missing Indexes

Ensure your indexes are achieving their fullest potential!

Performance Pitfalls of Code Reuse

Learn how object-oriented T-SQL hurts performance.

Why Your Datatype Choices Matter

Learn how poor data type choices can cripple SQL Server.