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.