Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Multiple Optional Parameters RE: Multiple Optional Parameters

  • December 4, 2008 at 2:27 pm

    #907945

    That kind of catch-all query doesn't perform well at all. On SQL 2000 there's no way to make it perform well

    Have a look at this thread - http://www.sqlservercentral.com/Forums/Topic599065-65-1.aspx

    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