G33kKahuna (12/3/2009)
Your arrogance is unbecoming. Perhaps we should take this offline
Jacek's article was debate worthy. I believe he and I don't see eye to eye on the evaluation approach .... he did clarify his position as well.
You jumped in the middle from nowhere with a pitbull attitude. You lacked skills to support your own argument or counter mine, not to mention lack of comprehension. Like I said before you offered, I would be more than happy to debate you offline but after your response from yesterday; it would be a waste of time .... cheers
That was not my intention and if I insulted you in anyway, please accept my apologies. I found the article insightful and was merely trying to support the author for his contribution. Feel free to PM me offline.
Updated this post to include an example; using the information below we were able to hone in on Procedure_C; closer inspection of the execution plan in the server side trace revealed a missing index; i.e.
Object Name # of Executions Avg_Reads Avg_Writes Avg_CPU Avg_Duration Max_Duration
Procedure_A30026830023413
Procedure_B292588202603
Procedure_C1835102010246251
Object Name< 11 - 2 Seconds3 - 5 Seconds5 + Seconds
Procedure_B2234512 134 0
Procedure_A2285510 118 0
Procedure_C1032418 235 150
Tommy
Follow @sqlscribe