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.