SentryOne Team Blog (blogs.sentryone.com)

Tag: cardinality estimator

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.

Pin the Blame on the Query

Last week's Visual Studio outage has been largely blamed on the cardinality estimator, but Aaron Bertrand (@AaronBertrand) says the query itself has a share of the blame.