Reading through this thread after the long w/e, I think people might be taking certain absolute conclusions about the way SS05 operates, specifically regards the optimizer (or lack thereof in some cases).

Some of you might be interested to revisit this old threadlet, discussing TVFs and RBAR, starting with a post I made: http://www.sqlservercentral.com/Forums/FindPost456536.aspx