Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pnpsql
Posting Yak Master
246 Posts |
 Posted - 2012-06-04 : 02:28:17
|
| I HAVE A PROCEDURE THAT UPDATES 5000000000 OF RECORDS IN APPROX 6 HRS. some times it executed in more than 1 hr. we have to check for completion in each 30 mins. after that we have to provide a go ahaed for the same. is there any solution for the same. the proc is alraedy tuned.challenge everything |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-04 : 10:07:04
|
| sorry didnt get what you meant bywe have to check for completion in each 30 mins. is it containing looping logic? are you referring to batches in between?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
proc message prompt