asked
Performance issue during Bulk insert
How to solve performance in Bulk import with index/non clustered index table. Example: Stored Procedure1: Inserting bulk records into table1 Stored Procedure2: retrieving data from table1 with certain condition Stored Procedure3: retrieving all the data from table1 case 1: Sometime we may face locking issue while retrieving data. Case 2: Applying isolation level Read Uncommitted we may get dirt read How to resolve this issue. Every interview people are asking this question. My answer is: ans1. Disable the index before doing Bulk insert.But this will impact select query ans2. Maintain only identity column with auto increment instead of primary key. Please help. how to resolve that.
Have you looked into -- Read Committed Snapshot Isolation?
16 People are following this question.
