Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning urgent help with stored procedure performance tuning RE: urgent help with stored procedure performance tuning

  • June 25, 2013 at 1:29 am

    #1627005

    Lucky9 (6/12/2013)

    I have a stored procedure to do the performance tuning, so below are the list of questions could someone please reply

    ...

    so with the above problem what is the best way to rewrite the sql query

    Can you post the Actual Execution Plans for the stored procedure? That's the quickest way for folks here to determine why your queries are slow.

    “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