Improving Performance with Intelligent Query Processing by John Morehouse

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 SQL Server 2019, 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 of how Intelligent Query Processing 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. About Speaker: John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. John leads the Omaha SQL Server user group for 7 years and is now a leader of the Louisville SQL Server/Power BI user group. He is honored to be a Microsoft Data Platform MVP, 2016 Idera Ace, Friend of Red Gate since 2015, Sentry One PAC member & Community Ambassador. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday's as well as other conferences. In his spare time, you can usually find John on Twitter (@sqlrus) as well as chasing his two young sons around the house. Conference Website: https://www.2020twenty.net/sql-server-virtual-conference/ C# Corner - Community of Software and Data Developers https://www.c-sharpcorner.com #MSSQL #IQP #Query #csharpcorner #conference #sqlserver