title: SQL Server index behaviour when doing bulk insert
body: <p>I have an application that inserts multiple rows at once into SQL Server.</p>
  
  <p>I use either <code>SqlBulkCopy</code> class or self-written code that generates a gigantic <code>insert into table_name(...) values (...)</code> statement.</p>
  
  <p>My table has several indexes and a clustered one.</p>
  
  <p>The question is: how are those indexes updated? For each row I insert? For each transaction? </p>
  
  <p>Somewhat odd question - is there a general term for this scenario, like 'bulk-insert indexing behaviour'? I tried to google several keyword combinations, haven't found anything. The reason I ask is because I sometimes do work with Postgres and would like to know its behaviour as well. </p>
  
  <p>I've been trying to find an article on this topic, several times, without any luck. </p>
  
  <p>If you can point me to any docs, article or a book with a relevant chapter, that'd be great</p>