I've restored a SS2K DB to SS2K8, new box with superior (virtual) hardware, however one of our views is running much more slowly.
On the old box it runs in 2 minutes, yet takes in excess of 20 on the new environment.
Rebuilt the indices and updated the stats on both DB's referenced in the view. Compatibility Level for both = 100.
Execution plan, Costliest Items (Old box)
61% Sort (Order By)
21% Table Scan (Where date greater than...Or 'Period' greater than...)
3% (x3) (Clustered Index scans)
Execution plan Costliest Items (New box)
53% Table Scan (Select from 2 DB's with implicit conversions not occurring on old box)
11% Table spool (Lazy)
7% (x3) Clustered Index scans
Thanks in advance for your help,