Pairing Query Store Read/Write Status with Enabled Status
1
vote
1
answer
101
views
I am able to find if Query Store is enabled:
SELECT name, is_query_store_on from sys.databases
I am able to query a specific database to determine the Query Store Read/Write Status:
SELECT actual_state_desc from sys.database_query_store_options
How do I join the two results to have the information in one table? They do not have a common field, and I assume I could write a
CROSS JOIN
to match the two tables up, but am unsure how without that common field.
Asked by CrushingIT
(33 rep)
Dec 16, 2021, 07:00 PM
Last activity: Dec 16, 2021, 08:02 PM
Last activity: Dec 16, 2021, 08:02 PM