Has anyone come accross this problem? I was getting incorrect results on a simple query using 'is null' when I changed it to '= null' it worked and was much faster. The execution plans were different, the first was doing an index seek on two indexes and a hash match, the second just on the one index. I also discovered a fix (MKBA 824028) and the workaround resolved the incorrect results