Not yet I will need to start logging, just wondering if anyone had seen this before. The file size on the properties tab is correct so I can only assume...

I have a tempdb database which showing the default 8Mb whe you look at shrink file, but on the disk it is 33gb.

What is going on?

To conclude this post,we have re-written the query to run in sql 2008. Re-indexing and updateing stats had no effect. We are on the lastest service pack/update.

I guess this is...

Tried your query and it does what si required, but I am still worried about the question, why has it query performance changed in SQL 2008?

Thanks for the reply, but my main concern about this is why this is occuring as we may be migrating lots of other systems accross and I need to know...

Thank you very much.

I think I understand the idea, as long as the resource for the application or instance are in the same cluster group then it does matter...

If a resource fails on one of the sql instances what will make the server failover. The way I understand it only one server if live at any one time...