Thanks for the feedback

The SQL2005 instance is on 32bit on a non-VM.

The SQL2008R2 instance is on 64bit running on VM.

Performance issue is the same on both machines.

--SAMPLE QUERY START--

select...