query-tuning

sp_query_store_flush_db, Query Store, and Backups

sp_query_store_flush_db, Query Store, and Backups

One of the cool things about Query Store is that you can back it up with the database.

This isn’t perfect for every situation, because you must back up the whole database. If you’ve got a multi-terabyte database, your Query Store isn’t super portable! But still, it’s great to have an option.