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 - 2002-05-22 : 10:29:11
|
| Michael Graham writes "I am currently trying to load a few files into a database I created. The files contain approx. 40 million rows with 18 cols each. Previous files imported fine. Now the loading will slow until the numbers no longer change on the import wizard status screen. I have let an import sit overnight...which should not be necessary, and it never finishes importing. I also receive no error message. I was thinking that the problem might be related to logs or some storage issue. I have plenty of space on my drive to store the data, and I have set the logging to simple. Nothing seems to help. I was wondering if anyone had suggestions for my problem? The CPU usage falls and no longer seems to be processing data. Yet the import isn't finished and i get no error.Any help would be appreciated.I am using SQL Server 2000" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-05-23 : 11:36:49
|
| Are you trying to commit the entire file of 40 Million rows as one batch? Maybe try setting the commit size down to a more reasonable number.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
Problems importing data into database