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 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!