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!