Community

Compatibility Levels and Cardinality Estimation Primer

(Glenn Berry) Between 1998 and early 2014, SQL Server used one cardinality estimator (CE), but would introduce a new database compatibility level with every new major version of SQL Server, (with the exception of SQL Server 2008 R2).