SQL Server Query Store Stuck in ERROR State: How to Fix it
A customer emailed me a couple of weeks ago with something that sounded, on the face of it, like a haunting. He’d been running ALTER DATABASE … SET QUERY_STORE = ON. The command succeeded. About ten seconds later, Query Store was off again. He’d tried this several times over several days and got the same … Read more