title: Simultaneous bulkinserts using ADO.Net against SQL Server, what indexes to chose?
body: <p>If I do simultaneous bulkinserts using ADO.Net against the same table using two different processes with separate connections each having a transaction with isolation level "ReadCommitted" against a table having:</p>
  
  <ul>
  <li>RowId:bigint identity</li>
  <li>FooId:uniqueidentifier PK Non Clustered (assigned upfront in code before bulkinsert)</li>
  </ul>
  
  <p>With regards to simultaneous inserts, would it be better to:</p>
  
  <ul>
  <li>a) put a PK on RowId with a clustered index and unique key contraint index, non clustered on FooId</li>
  <li>b) put a unique key contraint index, non clustered on RowId</li>
  </ul>
  
  <p>Any other tips?</p>