title: Why are there gaps in my IDENTITY column values?
body: <p>I have a problem.</p>
  
  <p>My ID Primary (IDENTITY) is configure to auto-increment (type: int). But, when I insert a new row, this new id is not consecutive. What is happening? Any solutions?</p>
  
  <p>EDITED:</p>
  
  <pre><code>[...]
  [id]int] IDENTITY(1,1) NOT NULL,
  [...]
  CONTRAINT [PK_Medida] PRIMARY KEY CLUSTERED
  (
  [id] ASC
  ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  </code></pre>