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.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]