Blog Post: SPD State Does Not Change If Adaptive Statistics Are Disabled

This post was originally published on this site

The aim of this post is to point out an issue (bug?) that I recently discovered. But, before talking about it, I need to go through a rather long introduction about the state of SQL plan directive (SPD). As of version, an SPD has two state information. You can see both of them through […]