SQLBits 2022
Intelligent Query Processing
Learn how enhancements to the SQL Server optimizer improve performance without code changes.
There many anti-patterns that SQL Server consultants find during query tuning
engagements. This is especially true at shops where developers use techniques that make
sense in procedural code to write T-SQL. Microsoft has made many advancements in the optimizer over the past few versions that overcome some of the issues with some of these techniques like table variables and user define functions. Attend this session to learn about these enhancements, when they will and when they won’t help performance without making code changes.
feedback link: https://sqlb.it/?7131
engagements. This is especially true at shops where developers use techniques that make
sense in procedural code to write T-SQL. Microsoft has made many advancements in the optimizer over the past few versions that overcome some of the issues with some of these techniques like table variables and user define functions. Attend this session to learn about these enhancements, when they will and when they won’t help performance without making code changes.
feedback link: https://sqlb.it/?7131