Man vs Machine: Adaptive query processing and auto tuning on SQL2017
Query optimizer is getting smart, computers are taking DBAs jobs. In this session MVP Fabiano Amorim will talk about new “automatic” optimizations on SQL Server 2017. Adaptive query processing, auto tuning and few other features added into the product. Are you taking weekend off? What about turn automatic tuning to avoid bad queries to show up after an index rebuild or an ‘unexpected’ change?