• Have you updated your statistics recently on both databases? If statistics are up to date on one and not the other SQL Server can generate or pick different execution plans for the same query.

    This too:

    SQLRNNR (12/20/2012)


    Also, please submit actual execution plans for both servers. It will help us to troubleshoot.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato