Our company would like to understand the effects:
1) If we have single table with Primary Key Identity column, int primary key IDENTITY(1,1),
2) and Application is conducting multi-threading parallel processing, trying to conducts 1000s of simulataneous inserts on one table.
Would the identity primary key column fail, with a primary key violation in any way, example: processors are trying to input the same identity number? Or was SQL designed to be successful even in multithreading parallel insert?
Note: IDENTITY_INSERT is OFF
asked Sep 09, 2017 at 06:08 AM in Default