Home Forums SQL Server 2008 T-SQL (SS2K8) Why is this code deleting only 1 row at a time instead of using the condition and deleting many rows? RE: Why is this code deleting only 1 row at a time instead of using the condition and deleting many rows?

  • July 18, 2014 at 3:54 pm

    #1730787

    I don't know why you would cursor through to delete a Log one record at a time.

    Why not change it to a set-based approach?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events