Home Forums SQL Server 2008 SQL Server 2008 - General Run time of Cursor RE: Run time of Cursor

  • October 15, 2012 at 6:37 am

    #1549097

    selvakumar.sms (10/15/2012)

    hi all

    i have stored procedure with 45 cursor, so the stored procedure taking long time to finish. is it possible to get running time of each cursor in the SP? , if yes please help me out.

    thanks

    Selva

    If you are unwilling to optimise all of this code as set-based queries, which most folks would recommend, then there is some scope for improving the performance of the cursors. I recommend you read this excellent article by Hugo Kornelis.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]