New tip with example on how to use SQL Server 2016 Query Store, how to track multiple execution plans and how to force an efficient plan.
Please read the latest MSSQL Tip: “SQL Server 2016 Query Store Example“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
SQL Server 2016 CTP 2.1 became available on June 24th 2015 about one month after Microsoft made public SQL Server 2016 CTP 2.0.
Today CTP 2.2 is available for download. Among all of the new Database Engine features Query Store stands out as a great addition to the performance tuning tools currently available out of the box.
Stay tuned for the MSSQLTips articles about SQL Server 2016 Query Store.