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!