KB3195752 - FIX: Wrong number of rows returned in sys.partitions for Columnstore index in SQL Server 2016


When you query for the number of rows of a Columnstore index from the sys.partitions system view in Microsoft SQL Server 2016, incorrect results are returned.


Note After installing the update you may have to rebuild the clustered column index to correct any previous wrong base count in sys.sysrowsets partitioning base-table metadata.

This fix is included in the following cumulative updates for SQL Server:

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

Latest cumulative update for SQL Server 2016


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology Microsoft uses to describe software updates.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!