SQL Cannot Produce Query Plan Error
Today I ran into the following SQL Server error while trying to run some Filtered Indexes:
Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.
In this post I go through the possible reasons for this Query Processor error, and how to solve each of those.