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 |
|
erictran
Starting Member
1 Post |
 Posted - 2009-09-28 : 04:33:06
|
| Hi All,I have a flat file 150GB (does not include primary key). Now I have to create and import it.It will take a very long time to import all data in that file. What is the best way in this case?I took me 2days to import more than 40GB. And take 40 minutes to run "select count(1) from Table" query. That is really bad.How do we deal with a huge db like that?Note: I own a server 2003, MSSQL 2005.Thanks for help!Eric. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-09-28 : 19:01:30
|
| What was the method you used to import the data? BCP works fast but 150 GB is still a LOT of data to be imported. Is this an occassional thing or a more regular type of import?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Import very big database file