• Sorry about my first post, I see you have already looked at the stats.

    Is there anything different in the EXECUTION PLANS.

    For Example a SCAN in test where there is a SEEK in live?

    Also is this a proc? if so it could be param sniffing!!!

    thanks

    Chris

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life