The Ascending Key Problem

You're constantly loading new sales data in, but when users run reports for recent sales like today or yesterday, you get bad query plans.

Brent Ozar will explain how statistics are involved, why you can't update them frequently enough to get it right, and how trace flags 2389 and 4139 help performance.

This session is for database administrators who are comfortable reading query plans and interpreting the output of DBCC SHOW_STATISTICS.

* Learn what the Ascending Key Problem is * See improvements in recent compatibility levels * Identify when those still aren't enough, and you need to use trace flags 2389 and 4139