Yes, we use filtered indexes to mitigate it. It's a lot of additional boilerplate though.