title: How do you like your primary keys?
body: <p>In a fairly animated discussion in my team I was made to think what most people like as primary keys. We had the following groups-</p>
  
  <ol>
  <li>Int/ BigInt which autoincrement are good enough primary keys.</li>
  <li>There should be at least 3 columns that make up the primary key.</li>
  <li>Id, GUID and human readable row identifiers all should be treated differently.</li>
  </ol>
  
  <p>What's the best approach for PKs? It would be awesome if you could justify your opinion. Is there a better approach that the above? </p>
  
  <p>EDIT: Anyone has a simple sample/algorithm to generate human readable identifiers for rows that scales well?</p>