title: Sql Server using DateTime as Primary Key
body: <p>Hi my questions is similar to:</p>
  
  <p><a href="https://stackoverflow.com/questions/5022579/mysql-using-datetime-as-primary-key">MySQL: Using DATETIME as primary key</a></p>
  
  <p>But I'm specifically interested in Sql Server and I want to approach the question practically with a specific scenario in mind rather than theoretically as in the other post.</p>
  
  <p>I want to store events/actions that users perform. The odds of more than one user performing an action in the same 100ms gap is very low and infrequent collision are acceptable. If I could discretely express 10ms or even 1ms gaps then I'm very happy with the risks. </p>
  
  <p>Thus begs the question, can I use a DateTime as my primary key instead of a unique identifier, because I will be regularly querying the latest 100 events and sorting the events by the time which they occurred.</p>