I want to know what is the best way to Delete records from Production DB. The scenario is, the user can Pick Up the file from Application to delete the whole batch. File data could be 30 rows or 2 Hundred thousand rows. Right now I am just using simple DELETE Statement DELETE MYTABLENAME WHERE ID = BATCHID. Know I am scared to use this statement it could possible to lock the table. I would like to know from all gurus out there, what would be the best way to delete the records in Production. I am not deleting records manually. Is the best way to use top 1000 and then next 1000... IF yes, Could you please show me the way, how it will work in 4 different tables. Please guide me it is urgent.