• mattech06 (5/27/2015)


    Can you see any easy optimizing of those statements (I know I haven't posted any data, sorry)

    I was about to say 'execution plans, table definitions and index definitions', then I realised you're doing this:

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    But other than that, table definitions, index definitions and execution plan please.

    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