Have you at least run update stats at 100% after you moved the db to SQL2008? Microsoft recommends rebuilding all indexes. Your access paths for queries are not going to be that good and that might be the reason you are running the query and it runs forever and you have to kill it. Probably doing some table scans.

You probably should run DBCC CHECKDB if you haven't already as well.