[dba-SQLServer] New database from hell

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



More information about the dba-SQLServer mailing list