Improving Performance With Intelligent Query Processing

Slow queries can be the bane of any data professionals existence. Let's face facts, no one likes it when query performance is abysmal. We continuously strive to tweak things attempting to ensure query execution is as fast as possible. What if we could magically make things faster with the push of a button or two? Now we can. Reborn from SQL Server 2017 Adaptive Query Processing (AQP) to Intelligent Query Processing (IQP) with SQL Server 2019, Microsoft brought forth enhancements making the query optimizer an efficient learning machine. With this new found knowledge, SQL Server can now generate better optimized queries with minimal effort. We will - • Discuss how IQP works behind the scenes • Show how to implement various IQP features • Look at real world demonstrations of IQP in action You are - • Interested in new SQL Server 2019 enhancements • Looking to make things faster with as little effort as possible • Looking for a reason to migrate to SQL Server 2019 Nobody likes slow queries. Nobody. Take advantage of these new features in SQL Server 2019 and see how much of an improvement can be gained. You won't be disappointed.