SentryOne Team Blog (blogs.sentryone.com)

Tag: compatibility level

Glenn Berry : Compatibility Levels and Cardinality Estimation Primer

Glenn Berry : Compatibility Levels and Cardinality Estimation Primer

Glenn Berry provides some details about how compatibility levels and the cardinality estimator have changed over the years, and why modern versions of SQL Server continue to be the better option.

Bad habits : Clinging to old compatibility levels

Aaron Bertrand (@AaronBertrand discusses a common scenario: behavior is different between two SQL Server databases that may be the same version but have different compatibility levels.