title: How to COMPLETELY reset a table
body: <p>When I run <code>sp_spaceused dummybizo</code> I get the following results:</p>
  
  <pre><code>name        rows    reserved    data    index_size  unused
  dummybizo   0       72 KB       8 KB    8 KB        56 KB
  </code></pre>
  
  <p>I am expecting the following results:</p>
  
  <pre><code>name        rows    reserved    data    index_size  unused
  dummybizo   0       0 KB        0 KB    0 KB        0 KB
  </code></pre>
  
  <p>What is causing the reserved memory?</p>
  
  <p>I have already tried to force a ghost record clean up with <code>alter table dummybizo rebuild;</code> but it doesn't change the results. I've also tried <code>truncate table dummybizo</code> but it doesn't do anything to these stats. I also note that <code>select * from dummybizo with (nolock)</code> doesn't reveal any hidden records.</p>
  
  <p>What should I try next? I would like to set up the table such that the stats read </p>
  
  <pre><code>0   0 KB   0 KB   0 KB   0 KB
  </code></pre>