Automatic Stats Updates Don’t Always Invalidate Cached Plans
Explains a SQL Server edge case where automatic statistics updates don't always invalidate cached execution plans, focusing on system-created stats.
Brent Ozar is a SQL Server performance expert and consultant who helps teams fix critical database slowdowns, improve reliability, and master SQL Server through hands-on consulting and world-class training.
23 articles from this blog
Explains a SQL Server edge case where automatic statistics updates don't always invalidate cached execution plans, focusing on system-created stats.
A debate on whether SQL Server DBAs need to know Windows clustering and if high availability features are worth the operational complexity.
Brent Ozar answers SQL Server, Azure SQL, and database management questions from viewers during an informal 'Office Hours' session in Tokyo.