We recently migrated from SQL 2005 to SQL 2008. Our SSRS reports worked fine in 2005. Now that we are in 2008, when a report is run from a single user the CPU spikes to 100% and often the report ends up timing out. We copied the database from our 2005 envirionment to our new 2008 environment. We rebuilt the stats and indexes.