Ratheesh.K.Nair (11/20/2012)
In the procedure they are deleting values before a particular date.Values are deleted from a master table and inserting into a another table.
Smaller chunks in the sense changing the date value to a shorter period will help??
This article may be of assistance: Deleting Large Number of Records[/url].