Posted - 07/22/2013 : 10:15:47
I am using SQL 2008 R2.
I have one stored procedure in that 6 insert statement and 2 update statement.
If i run 1st insert statement it is taking max 30 seconds to execute, for 2nd insert statement it is taking max 20 seconds to execute,
for update statement 10 seconds.
If i run all the three it taking more than 15 mins.
Please any idea...?
Thanks in advance...