440692 I am just a number (1/3/2012)
Jeff Moden (12/28/2011)
To be sure, I made a terrible mistake. [font="Arial Black"]ISNULL isn't SARGable.[/font]That is just a perspective thing.
Your 'terrible mistake' challenged something I believed to be true and highlighted a lots of things I didn't know.
Three days into the new year and I now have a much better understanding of how indexes are used.
I think it is going to be a good year.
Many thanks to yourself, Hugo and Paul
Thank you for the kind words. And, I agree... once again, the discussions are what really paid off on these fine forums.
--Jeff Moden
Change is inevitable... Change for the better is not.