May 2019
Intermediate to advanced
484 pages
11h 23m
English
Azure SQL Database has the Query Store enabled by default. However, on SQL Server, it must be enabled manually. This can be done in two different ways:
USE [master]GOALTER DATABASE [AdventureWorks2016]SET QUERY_STORE = ONGOALTER DATABASE [AdventureWorks2016]SET QUERY_STORE (OPERATION_MODE = READ_WRITE)GO

In the previous ...