punsaonline (5/19/2009)
If Microsoft would have think that then you might not get 2005, then 2008 so on, as database service was working fine earlier with 2000 also.I was just looking at different methods of writing a same query and i got fixed with that problem.
You are comparing apples (your queries) to oranges (sql server engine).
If you want to know why one version of the query is better than the other, you will need to compare the actual execution plans of the queries which means letting them both run to completion.