title: sql server 2008 partitioning column
body: <p><a href="http://msdn.microsoft.com/en-us/library/aa933141%28v=sql.80%29.aspx" rel="nofollow">According to microsoft</a> An Identity column cannot be a partitioning column canadate.</p>
  
  <p><em>The partitioning column cannot be an identity, default or timestamp column.</em> </p>
  
  <p>They do not clarify why that is nor has my google foo turned up a reason. </p>
  
  <p>I have a theory, can SqlServer not automatically insert the row into the correct shard based on the identity field if it is the partitioned column? </p>