Skip to content

Instantly share code, notes, and snippets.

@airtank20

airtank20/Improving Performance with Intelligent Query Processing.md

Created March 6, 2020 01:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save airtank20/70cde9498f4f86a951fd946e8f2a4c83 to your computer and use it in GitHub Desktop.
Save airtank20/70cde9498f4f86a951fd946e8f2a4c83 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Improving Performance with Intelligent Query Processing.md

Improving Performance with Intelligent Query Processing

One of the core pillars in the role of a database administrator is to ensure their systems run as efficiently as possible. We don't sit around and want a SQL Server to run slower, so we implement steps to ensure our SQL servers perform at maximum capacity. Rebranded from SQL Server 2017 Adaptive Query Processing (AQP) to  Intelligent Query Processing (IQP) with, Microsoft continues to bring forth enhancements in making the query optimizer a learning machine to help intelligently improve performance. Walking away after this session, you'll have a better understanding on how IQP features, such as scalar user defined function improvements, table variable deferred compilation, or adaptive joins, will help ensure your SQL Servers run at optimal performance.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment