[AccessD] New database from hell

Janet Erbach jerbach at gmail.com
Fri Mar 23 12:54:33 CDT 2012


WOW.  Talk about a kitchen sink table!

On Fri, Mar 23, 2012 at 12:39 PM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>


More information about the AccessD mailing list