SQLBits 2020

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!

Is your code filled with scalar functions and table variables and suffering as a result? In my mind, these are among the most common yet problematic T-SQL anti-patterns.

But now, Microsoft has introduced Intelligent Query Processing to mitigate them without changing a single line of T-SQL! Come to this session to see how SQL Server 2019 fixes these performance killers!

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.