Who doesn’t like Filtered Indexes, am I right? They’re pretty great, honestly. If… of course… you’re able to actually create them and utilize them in your specific use cases. That… unfortunately, could often become a complicated, if near impossible, task. So, what if our use case is not trivial enough to allow for filtered indexes?
The full post was published at the Madeira Data Solutions official blog site:
Filtered Indexes with TRY_CONVERT, ISNUMERIC, and other complex expressions