Sorry that was a tupo, its not 10K items , its 100K items. Considering the fact that we have 16MM records and 33 index on the item table.
Rows have 72 columns. No blob involved. 32 index, 2 delete triggers, 10,000 batch Size. Yes there are lot of blocking going while this is running for any process that uses this table
Yes we do see table level lock. Other process gets locked when this is running. Insert bulk for 100K rows runs in batches og 10,000.