Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, changing the table structure is not blocked by the presence of the statistic. An auto-created statistics is also dropped automatically when a schema change happens. On the other hand, if the statistic is created by the user, any schema change will be blocked by the presence of the statistic. The Auto-Drop setting on a statistic is a new SQL Server 2022 feature to change this behavior.
Month: November 2023
Smarter, Faster, Better: Intelligent Query Processing in SQL Server 2022
In the evolving landscape of database management, the need for faster, more efficient query processing is paramount. SQL Server 2022 takes a significant leap forward with its Intelligent Query Processing (IQP) feature, a testament to the ongoing quest for performance optimization. This blog post explores the essence of Intelligent Query Processing in SQL Server 2022, why it’s a game-changer, the improvements it brings, and how to maximize its potential.
SQL Server 2022: Improving Database Performance with Enhanced Parallel Redo
In the world of database management, SQL Server has consistently pushed the boundaries of performance and efficiency. The release of SQL Server 2022 marks another milestone, particularly in the realm of parallel redo operations. Let’s delve into how SQL Server 2022 transforms the landscape of thread management and batch redo, overcoming the limitations of its predecessors.
The Art of Resolving HADR_SYNC_COMMIT Waits in SQL Server
Navigating the complexities of SQL Server’s Always On Availability Groups can sometimes feel like solving a complex puzzle. One such challenging aspect involves understanding and resolving wait types related to Hadr_sync_commit. These wait types are like intricate clues that can reveal potential performance bottlenecks or issues in your Always On setup.
DBA to the Rescue: Mitigating the Impact of SQL Server Corruption
Let’s talk about the boogeyman of our database world – corruption. Not the kind that lands you in headlines, but the sort that can turn a perfectly tuned database into a digital wasteland overnight. It lurks in the shadow of failing hardware, creeps behind the veil of sudden power losses, and sometimes piggybacks on the most innocent-looking software bugs.