SQL Insights

SQL Server Doesn't Like Filtered Indexes

Even when you create a filtered index, if another index satisfies the query, the SQL Server optimizer will ignore the filtered index. Filtered indexes are great in theory, but difficult to implement in practice. You might consider using a query hint, but generally, those are not recommended.

I've included an article in the comments that provides an example of why SQL Server ignores your filtered indexes.

Filtered Indexes Ignored in SQL Server