Think Like the Cardinality Estimator

Think Like the Cardinality Estimator

PASS Data Community Summit via YouTube Direct link

Murphys Law

16 of 28

16 of 28

Murphys Law

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Think Like the Cardinality Estimator

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Introduction
  2. 2 Housekeeping
  3. 3 Session Evolution
  4. 4 How to contact me
  5. 5 About the session
  6. 6 Definitions
  7. 7 Pred selectivity
  8. 8 Example
  9. 9 Density
  10. 10 Density Example
  11. 11 cardiology estimation
  12. 12 SQL estimation
  13. 13 Execution plan
  14. 14 Why Cardinality Matters
  15. 15 Effects of Cardinality
  16. 16 Murphys Law
  17. 17 DBCC Statistics
  18. 18 Histogram
  19. 19 Explanation
  20. 20 Versions
  21. 21 Compatibility Level
  22. 22 Updated Stats
  23. 23 Actual Execution Plan
  24. 24 Multiple Predicates
  25. 25 What Changed
  26. 26 Parameter sniffing
  27. 27 Unknowns
  28. 28 Ascending Key

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.