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 |
|
frlep
Starting Member
4 Posts |
 Posted - 2008-03-11 : 10:14:18
|
| Hi,Please can you help me,I have created an database with 3 indexed (not clustered) fields key : bytes 100 error : integer status : bytes 6I would like to know how to import 3 million or more records quickly.If I don't index the the fields, the operation takes 3 hours. With indexed fields it takes overnight. Therefore, how can i optomise the import operation from a .txt file.Thanks and regards. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-11 : 10:48:36
|
| Have you tried BCP? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-11 : 11:41:16
|
| Please dont replies as new topicshttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98800 |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-11 : 11:50:30
|
| This topic has more information on it, so probably better to reply here. |
|
|
|
|
|
|
Optimise import text file