Stored procedure
-
Hi, I have written a stored procedure in which some insert and update statements are there. This SP i'm running in my local PC and inserting & updating some tables from remote sql server to my local sqlserver. Now the problem is that this SP is taking too much time to execute, app. 5-7 min. Now plz advice me some optmize solution for this. Thanx...
krishna veer singh
-
Hi, I have written a stored procedure in which some insert and update statements are there. This SP i'm running in my local PC and inserting & updating some tables from remote sql server to my local sqlserver. Now the problem is that this SP is taking too much time to execute, app. 5-7 min. Now plz advice me some optmize solution for this. Thanx...
krishna veer singh
There's far too little information here for anybody to offer you reasonable help. If I were you, I'd look to run a SQL profiler on the stored procedure and analyze the results from this. This will tell you where your holdups are.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith
As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.