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 - 2005-05-04 : 07:56:33
|
| Dasun writes "i got a problem is data loading from one table to another in the same database. it take long time to copy data. per min it copies only 400 rows. is there a way to stop writing to the log file. i think in each insert command sql server writes to the log file. i have done maximum optimizations (in code wise) to stored procedure which is used to copy the data. but still no luck....during the data import the memeory consumtion of the sqlserver goes upto 1500000K. any idea ..........." |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-05-10 : 18:28:53
|
| Hey,1. Change the Recovery model of database to SIMPLE.2. Use BULKINSERT OR BCP tool to Import the data.3. Drop Or Diable all Indexes on the table and try again.Hope it will :-)ByeWith RegardsSreenivas Reddy B |
 |
|
|
|
|
|
Data Import