My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Query Optimisation in SQL Server 2005
The new RSS feed is here
Of the questions that get asked on the forums many are wround query optimisation and trying to understand why certain queries run one way and others another, hopefully the new blog from the query optimiser team will help the understanding.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Query Optimisation in SQL Server 2005