A Bug With OBJECTPROPERTYEX And Column Store Indexes

No, Not That Bug

There’s a known bug with partitioned tables, but this is different. This one is with rows in the delta store.

Here’s a quick repro:

In Pictures

In Particular

This is the interesting bit, because you can obviously see the difference between open and compressed row groups.

Give us money

The 50k rows in the delta store aren’t counted towards table cardinality.

Thanks for reading!

Leave a Reply

Your email address will not be published. Required fields are marked *