Dualcore DBA searches for a person:
In this post, we’ll look at how filtered indexes in SQL Server work when the query is parameterised on the column of the filtered index.
I’ll skip my normal rant about how filtered indexes are so powerful and useful, yet so limited in how we can actually use them.