Why Database ID Order Matters When Using Query Store to Force Plans With AlwaysOn AG
When combining AlwaysOn Availability Groups and Query Store, it is possible to fail over and have a plan that is forced not be used on the new primary if you have queries that involve temporary tables or table variables. This article describes in detail how that can happen.
