- In Microsoft SQL Server 2005, you have a query that contains a predicate.
- The predicate contains the IS NOT NULL clause and another condition that are combined by the OR operator on the same column. For example, the query contains one of the following predicates.Example 1
y like 'a%' or y is not nullExample 2
a=@p or a is not null
- You have an index on the column.
- You run the query.
The fix for this issue was first released in Cumulative Update 3 for SQL Server 2005 Service Pack 3. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
Description of the standard terminology that is used to describe Microsoft software updates
Article ID: 969021 - Last Review: Jun 11, 2009 - Revision: 1