>Set Ansi On - shows the exact same things now in sys(3054) and works just as fast.
>
>Here is the link:
>http://www.ms-news.net/f1342/strange-behaviour-when-joining-2-tables-10694727.html
>
>I actually remember this now. But it's been so long!
>
You're right, I think it was discussed here at some point also. Glad you found it.