This non-flat data does not fit comfortably within flat SQL databases, and consequently, is handled poorly and queried with great effort, though significant resources are spent to produce, collect and ...

I have to import flat files into MSSQL server. So far, I've used SSIS packages and Delphi programs to do the job but I'm getting more and more files to load. Many are very wide (more than 90 fields) ...

In this flat file database, the data on each member of staff is held together with all data for each department. This is unnecessary as some information is stored more than once (eg the same phone ...