Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Costly update trigger -70,000,000 logical reads for 30,000 rows updated! RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

  • February 2, 2009 at 8:45 am

    #936474

    Peso (2/2/2009)

    The trigger is updating the same base table on where the trigger is resided.

    So when the trigger updates the two columns, the same trigger is fired again!

    And again.. And again...

    Wow, would the trigger feed on itself that way? I hadn't thought of that...

    How many iterations would that involve?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]