title: SQL DELETE - Maximum number of rows
body: <p>What limit should be placed on the number of rows to delete in a SQL statement?</p>
  
  <p>We need to delete from 1 to several hundred thousand rows and need to apply some sort of best practise limit in order to not absolutely kill the SQL server or fill up the logs every time we empty a waste-basket.</p>
  
  <p>This question is not specific to any type of database. </p>