Home Forums SQL Server 2005 SQL Server 2005 General Discussion Really Slow query when i add a query to select statement RE: Really Slow query when i add a query to select statement

  • March 21, 2014 at 8:16 am

    #1699098

    Then you might want to look at this next:

    where convert(varchar,DESPATCH_NOTE_DATE,111) >= @date

    This expression means that any index on DESPATCH_NOTE_DATE can't help. Rather than converting DESPATCH_NOTE_DATE to match @date, do it the other way around: convert @date to match the datatype of DESPATCH_NOTE_DATE.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden