SQL Tips #14 - Clearing the Query Store

The Query Store can grow large over time - this one-liner clears it out for a database.

The Query

ALTER DATABASE [dbname] SET QUERY_STORE CLEAR;

Disclaimer

These queries are provided as a guide, and are by no means perfect. I didn't write all of these - many are collated from MSDN documentation and community sources over the years.

Tags