Erland Sommarskog (9/20/2013)This is typically what you see when a module is compiled. Since the new trigger includes a more complex query than the old trigger it takes longer time to compile, but if the plan stays in cache, this overhead can be neglected.
Thanks, I noticed that when I removed the DBCC commands the execution with the new trigger was faster, but for performance measures I always do the DBCC... Or should I just do the DBCC for the data cache (if there's just that one)?
Maybe just http://technet.microsoft.com/en-us/library/ms187762.aspx.
Thanks,
Pedro