Bugbash
At some point in the past, I blogged about a silent bug with computed columns and clustered column store indexes.
In this post, I’m going to take a quick look at a very loud bug.
Normally, you can’t …
Category: Bugs
A Silent Bug With Clustered Column Store Indexes And Computed Columns In SQL Server 2019
Oh Boy
This bug has been reported to the proper authorities, and this blog post is not to dunk on the Summer Intern responsible for column store indexes, but to warn you to not do this, because I don’t know …
Why Filtered Indexes Are Broken In SQL Server
Fix Your Indexes, Pal
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m …
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:
USE tempdb; DROP TABLE IF EXISTS dbo.busted; CREATE TABLE dbo.busted (…
CHECKDB Bug With SQL Server 2017 And ColumnStore Indexes
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for consulting…
A SQL Server Query Plan Memory Grant Bug?
Yes, That’s A Question
I have no idea if this is a bug or not, but I thought it was interesting. Looking at information added to spills in SQL Server 2016…
If you open the linked-to picture, you’ll see …