As a rule I always run DML sql statements within a Transaction using BEGIN TRAN when Creating, Updating & especially Deleting data to make sure that any changes can be easily rolled back. Using DELETE should never be an issue as long as you are careful and allow for roll back and even backing up data in case something goes wrong.