Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Problem with "If Exists (Select ...) Or Exists (Select ...)" RE: Problem with "If Exists (Select ...) Or Exists (Select ...)"

  • January 9, 2013 at 7:15 am

    #1575230

    Unfortunately I would need to see more info to really help with this. It's not a standard or known problem with a well documented solution. Could be a million things.

    For now, can you ask that client to run a full stats updates on any tables that those selects affect?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass