I hope you enjoyed my talk earlier today.
The Slides and Demo Scripts:
Further Reading
- Joe Sack’s Whitepaper Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
- Joe Sack’s CE blog posts at SQLSkills Cardinality Estimation
- Kendra Little’s The SQL 2014 Cardinality Estimator Eats Bad TSQL For Breakfast
- Paul White’s Cardinality Estimation for Multiple Predicates
- Microsoft’s research paper Testing cardinality estimation models in SQL server(ACM pay site)