Statistics 07 - The Ascending Key Problem

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.