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.