title: Delete large amount of data in sql server
body: <p>Suppose that I have a table with 10000000 record. What is difference between this two solution?</p>
  
  <ol>
  <li><p>delete data like :</p>
  
  <pre><code>DELETE FROM MyTable
  </code></pre></li>
  <li><p>delete all of data with a application row by row :</p>
  
  <pre><code>DELETE FROM MyTable WHERE ID = @SelectedID
  </code></pre></li>
  </ol>
  
  <p>Is the first solution has best performance?
  what is the impact on log and performance?</p>