Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2014-07-15 : 04:54:03
|
| Hi. The file has 500.000 records. I was thinking on doing a bulk insert but the manager want the process to be as fast as possible but not to lock the table.The table will have an AA => PK, Autonumber and the rest is the data.So what is the best way to do that.I am a little confused about using TABLOCK . Will this improve performance? But will it also lock the table? Is the transaction level default the way to go?What else can be done?Thanks in advance. |
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2014-07-15 : 04:56:36
|
| Also, should i drop the PK index in bulk insert and recreate it? I'm a little confused about that also. |
 |
|
|
|
|
|
Need to insert big file in DB help.