First published on MSDN on May 12, 2006
A typical programmer may expect that the predicates are always evaluated in the order that they are specified, but this is not true ...
Updated Mar 23, 2019
Version 2.0
Blog Post
This example appears to no longer be valid. I guess Query Optimizer has been improved to anticipate these situations. Please provide a more suitable example, as I suppose this issue can still occur under different circumstances.