Erik Darling points out a weird bug:
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 add a filtered index to a computed column. I’ve always hated that limitation. How nice would that be for so many currently difficult tasks?
Click through to see how you can create a filtered index against a computed column, as well as all of the pain it provides.