How many times have you faced bad performances caused by incorrect rows-estimation or caused by multi-statement user-defined table valued functions? Have you ever seen a warning on Sort operator that spills data on tempdb caused by inadequate memory estimation? These are not the only problems we could have with queries optimization, but these are the three problems that SQL Server 2017 Adaptive Query Processing attempts to address. SQL Server 2019 introduces additional features and all of them are known with the name Intelligent Query Processing. This session will cover the Adaptive Query Processing first. Next we will cover briefly the features implemented in the latest CTP of SQL Server 2019.
Accompanying Material: sqlsaturday.com/895/Sessions/Details.aspx?sid=96744