title: Why is IDENTITY preferred over GUID as primary key for data warehousing?
body: <p>I love my GUID. However, lately I have been doing some research to understand the actual pros/cons over IDENTITY for primary keys and I found <a href="http://databases.aspfaq.com/database/what-should-i-choose-for-my-primary-key.html" rel="nofollow">this article</a> which summarize it quite nicely.</p>
  
  <p>In the article the author has put:</p>
  
  <blockquote>
    <ul>
    <li>highly useful for data warehousing;</li>
    </ul>
  </blockquote>
  
  <p>as one of the pros for using IDENTITY over GUID.</p>
  
  <p>I would understand that with particularly large databases, as with data warehouses, the size does matter - however it would appear there are other reasons which the article fails to explain. So I ask:</p>
  
  <p><em>Why is GUID a bad idea for date warehousing?</em></p>