dm_tapas (11/1/2011)
The below stored procedure is taking around 1 hours to execute. but it should not take this much time. Can some body tune this and tell me where is the problem....?...
I don't find any..
I am helpless regarding this. somebody help!!!!!
Thanks in advance.
What makes you believe that the stored procedure "should not" take an hour to execute?
Has it ever ran in significantly less time that that?
Pasting the code to SSMS, you can "display estimated execution plan" in production, and it will at least provide some clue about which statements or operations have the highest % cost relative to the entire batch, so you can then zero in on specific problem areas.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho