FIX: Access violation occurs when automatic statistics update happen on tables with incremental statistics in SQL Server 2017

Applies to: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows

Symptoms


Consider the following scenario:
  • You have incremental statistics that are built on partitioned tables in SQL Server 2017. 
  • You merge or split a partition.
  • The statistics are automatically updated.
In this scenario, the incremental statistics tree may become corrupted, and you notice that an access violation occurs.

Resolution


The issue is fixed in the following cumulative update for SQL Server:
About cumulative updates for SQL Server:

Each new cumulative update for SQL Server contains all thehotfixes and all the security fixes that were included with the previouscumulative update. Check out the latest cumulative updates for SQL Server:

References


Learn about the terminology thatMicrosoft uses to describe software updates.