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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-13 : 08:13:10
|
| LECONT writes "HI,I am inserting data into a table from another table using "insert into table1 select * from table2".Will it be a performace hit if the number of records to be inserted is large? If so what is this comapreable to bulkinsert from a file?TIA,LECONT" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-08-13 : 08:49:43
|
| bulk-insert will be faster....but bulk-insert has no transaction logging...so if the insert fails...you'll have to re-startOnly way one can compare 1 with the other is to do a 'test'!! |
 |
|
|
|
|
|
data insertion-performance issue