This was first posted on October 4, 2016 by Rick J
I have a similar question.
When running a procedure, it takes 27 seconds.
When running exactly the same procedure with tracing on, it takes 89 seconds.
Did anyone ever get a reasonable explanation about what is happening and why there is such a huge difference?
PS: Obviously, it has nothing to do with the procedure itself. In both cases, the same procedure is used with exactly the same data.