Skip to content
  • Training
  • Consulting
  • First Responder Kit
  • Blog
    • Popular Topics
    • Well, Actually...
  • Videos
  • Log In
Newsletter

07. The Ascending Key Problem (11m)

In data warehouse scenarios where you constantly load in new data every night, and then go query the data you just loaded, you often get really bad execution plans. We explain why.

[wpc_button]

06. Filtered Statistics: ENHANCE! (15m) 08. 10 Rules for Managing Statistics (12m)

In this class

Statistics: SQL Server’s Guessing Game
  • 01. A Tale of Two Plans (7m)
  • 02. Getting to Know Statistics (15m)
  • 03. Combining Multiple Single-Column Statistics (8m)
  • 04. Multi-Column Statistics and the Cardinality Estimators (14m)
  • 05. What Is the Cardinality Estimator? (5m)
  • 06. Filtered Statistics: ENHANCE! (15m)
  • 07. The Ascending Key Problem (11m)
  • 08. 10 Rules for Managing Statistics (12m)
  • 09. Seeks, Scans, and Sargability (9m)
  • 10. How Execution Plans are Made (10m)

SQL Server training, consulting, and thousands of pages of free help.

Get the newsletter

Training

  • Live classes
  • Recorded classes
  • Corporate training
  • Log In

Free Help

  • First Responder Kit
  • Blog
  • Videos
  • Newsletter

Company

  • Consulting
  • About
  • Contact
© Brent Ozar Unlimited®. All rights reserved. · Privacy