|
pnpsql
Posting Yak Master
India
244 Posts |
Posted - 06/04/2012 : 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 |
|