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

  • October 15, 2012 at 5:03 am

    #1549068

    sql-programmers (10/15/2012)

    Hi Dude,

    Instead of using CURSOR you can try WHILE loop like below example.

    If possible dont use CURSORs in the procedure.

    A well written forward-only readonly cursor will perform similarly to a WHILE loop. Changing this stored procedure to using WHILE loops instead of cursors will cost a great deal of time and run the risk of introducing errors - and may not improve performance at all.

    A stored procedure using 35 cursors suggests naive coding - but it may not be the case; maintenance routines commonly (and correctly) use cursors. Without seeing the code, you're guessing.

    [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]