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 - 2004-02-25 : 07:46:05
|
| Andrew writes "Is there any way to speed up a table insert? We use Sql 2000 on Windows 2000" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-25 : 07:51:29
|
| 1. Don't use cursors.2. If you're using ADO, don't use the AddNew method.3. If you have many rows, use INSERT INTO....SELECT instead of multiple INSERT INTO...VALUES statements. Books Online has syntax for the INSERT statement.4. If you have a lot of data in a file, use bcp or BULK INSERT to import it. Books Online has details on these as well.Without more detail on what exactly you're inserting and what your tables look like, I don't think there's much more we can provide. |
 |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-02-25 : 07:51:49
|
| Hmm... Use less data! (I'm in the noughty mood today) |
|
|
|
|
|
|
Speeding up table inserts