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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Database Creation

Author  Topic 

scorpio0077
Starting Member

1 Post

Posted - 2009-06-03 : 21:20:23
Hello All, I am a newbie to SQL Server and database creation and I need some guidance with regards to creating a database.

I am currently working with data from airlines, where I have the daily flight information for a large number of airlines for about 90 days.

Issues:
1. The data is about 100 different flat files (csv)
2. The net data size is around 20 GB.
3. The data has only 8 columns, but a large number of rows
4. The data is almost clean and can be readily modified

The data is to be used to run a few analysis(mainly statistical)

The best way I felt was to create a database. I would appreciate any help on how I should start off on the project would help, as I have not created databases before. However, I have written SQL queries and I am a proficient Excel user.
   

- Advertisement -