Kurt W. Zimmerman (11/1/2013)
Mike.brickles (11/1/2013)
I moved the tables by using the import and export dataI really dont know much about sql at all
Are the 2 schemas the same? Indexes, statistics? Have you reindexed the tables? Are statistics up to date?
Kurt
That's it. When you use the import/export wizard, the table structure and data are copied, but the keys, constraints and indexes are not. You'll need to update the table on 2008 to match the one in 2008 to be able to compare apples-to-apples.