title: Sql Server Identity column -> values get reused?
body: <p><em>Not sure if I'm over-thinking about things here... but ..</em></p>
  
  <p>I'm using MS Sql Server (I'm interested in answers for 2008 / 2012 / 2014).</p>
  
  <p>I have a simple Table which has an <code>Identity</code> field. Each time a new row is inserted, it auto-gen's the Id. Started at 0 with an increment of 1. Basic stuff.</p>
  
  <p>When ever I update a row, I'm doing a <code>DELETE</code> and then <code>INSERT</code>. (Yes, i know about <code>MERGE</code> and can use that, but I'm not).</p>
  
  <p>Right now i'm at <code>Id: 11952106</code>.</p>
  
  <p>There's lots of numbers that have been unsed. Eg. <code>1, 2, 3</code> .. etc.. I did use them but then deleted them</p>
  
  <p>So .. <strong>will Sql Server ever start to use those 'gap' numbers?</strong> (Not sure of the tech term for that).</p>