I put this in the Bonus section because it's something that's just cool to know, but the vast, vast majority of you are never gonna face a problem with this.

The Ascending Key Problem is when new data constantly comes in past the high water mark of the statistics histogram, and SQL Server can't accurately estimate the newly loaded data.