It would certainly help to see the query, as well as the CREATE TABLE and CREATE INDEX statements for the table.

There is little reason to look at the hardware, when there are so apparent difference in the query plan. The plan you get on SQL 2008 scans the entire table, which I assume is some 8 GB in size.