Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Trigger Issue... RE: Trigger Issue...

  • September 24, 2013 at 7:05 am

    #1652710

    Erland Sommarskog (9/24/2013)

    PiMané (9/23/2013)

    I'll do a CHECKPOINT and DBCC DROPCLEANBUFFERS to free the data but keep the execution plans and compiled SP and triggers, since that's what will happen.

    Again, since you are replacing the trigger between the tests, you will see compilation first time anyway. Just discard the first execution.

    Yep. that's what I did. I'm making 10 runs each time and ignoring the 1st execution.

    Thanks for all the help,

    Pedro


    If you need to work better, try working less...