Can anyone help with a delete process for sql server 2005?
We are in the process of deleting a large number of rows from muliple tables. Since we are not deleting all the rows from any one table we cant just truncate the table.
Our process will use delete statements and delete based on ids. Since this might run for a day should we use delete with rowlock? Should we also put the delete statments in one transaction? Any other ideas would be apprectiated.