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 |
|
efinkelb
Starting Member
4 Posts |
 Posted - 2008-01-21 : 12:35:04
|
| Hi guys. Well, I think the main subject is self descriptive...I have to copy many rows as fast as I can. What is best performance?1. INSERT [TABLE1] (FIELD1, FIELD2) (SELECT (FIELD1, FIELD2) FROM [TABLE2])2. DTSThanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-21 : 13:11:15
|
| dts data pump task is usually faster. not always. is source and target on same server? if not, i'll definitely go with dts |
 |
|
|
efinkelb
Starting Member
4 Posts |
Posted - 2008-01-23 : 06:57:12
|
| Thanks for your answer. Yes, source and target are on the same server. |
|
|
|
|
|
|
Performance: DTS vs T-SQL