Bobby Glover (3/23/2013)
Thanks Steve, but what I'm trying to find out is what problems occur with it in SQL 2008 SP1.
In 2008 SP1 the behaviour is exactly the same as in 2005, ie you still get the poor plan.
Basically, what happened is this:
SQL 2008 RTM: Attempt at creating optimal plan not safe for reuse. Resulted in an incorrect results bug. ie, not something you want to do.
SQL 2008 SP1: Feature to create optimal plan not safe for reuse removed because of said incorrect results bug
SQL 2008 SP2: Feature re-added correctly.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass