I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly affect your cardinality estimation in some cases and therefore your execution plans. The Ascending Key Problem relates to the most recently inserted data in your table … Continue reading Statistics and the Ascending Key Problem