jwcolby
jwcolby at colbyconsulting.com
Fri Mar 23 12:39:21 CDT 2012
I received a new "database from hell" today. This one is actually CSV format. It came with a table specification which in no way matches the actual file. However it appears to be importing in with just a few minor changes to the default 50 character default field width that the SQL Server import wizard uses. The file came in a 24 gigabyte zip file. Expanded it is 250 gigs. Way to large for even UltraEdit (my tried and true champion) to open. So I was unable to preview the data. However I just used the SQL Server import wizard to open the file and start looking at it. SQL Server truly is an amazing piece of work. No firm idea yet on the number of rows though I was told well over 100 million. 430 columns. -- John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it