Intelligent Query Processing

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:

Starts: 14:40 12th Mar 2022
Ends: 15:30 12th Mar 2022


Short Description
- Learn how enhancements to the SQL Server optimizer improve performance without code changes.

Slidedeck Link

BITS Intelligent Query Processing.pdf


Kathi Kellenberger


AzureOn PremisesData IntegratorOperational DatabasesDevelopingAzure SQL DatabaseSQL 2019SQL 2022IntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.