My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Performance when migrating from SQL 2000 to SQL 2005
The new RSS feed is here
If you are restoring a SQL 2000 DB to SQL 2005, make sure you rebuild your indexes and update your statistics. A number of people have found performance poor after the upgrade but sorted out once the above has been done.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Performance when migrating from SQL 2000 to SQL 2005