Jason Selburg (9/12/2012)
Did you rebuild statistics?I do believe that even though the servers may be configured the same/same hardware, when you restore a database the stats get "out of whack".
I may be wrong, and if I am someone will most likely point it out here. :w00t:
A restore will not affect the statistics. A restore gives us an exact page-for-page database as existed when the database was backed up.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato