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 6:42 am

    #1575216

    In case you missed this...

    GilaMonster (1/9/2013)

    Any chance you can post an execution plan for the first one? What is the wait type that the query has during those 10 minutes? The wait type will give us an idea what is causing the delay.

    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