Sometimes things don’t work out as planned. The same thing happens to our SQL Server execution plans. This can lead to horrible slow queries, or even queries failing to run at all. In this session you will see some scenarios demonstrated where SQL Server produces a wrong plan, you will learn how to identify them and what you can do to avoid them.
You will also learn more on Adaptive Query Processing, a new feature in SQL Server 2017. This allows your SQL Server to adjust wrong plans while the plan is being executed. So, if running queries performantly is one of your concerns, don’t miss out on this session!