title: Clustered vs NonClustered Primary Key
body: <pre><code>begin transaction;
  create table person_id(person_id integer primary key);
  insert into person_id values(1);
  ... snip ...
  insert into person_id values(50000);
  commit;
  </code></pre>
  
  <p>This code takes about 0.9 seconds on my machine and creates a db file taking up 392K. These numbers become 1.4 seconds and 864K if I change the second line to</p>
  
  <pre><code>create table person_id(person_id integer nonclustered primary key);
  </code></pre>
  
  <p>Why is this the case?</p>