mercredi 7 janvier 2015

what could be the Best practices with very very large amount of data


I have a question on building a solution.I have a few txt/csv file having huge amount of data approx 30000000000 rows .By size they are 1.5 TB.The tables based on these data are only for lookup,I mean, there will be no update or insert or delete. So please guide me as how to plan and proceed. Should I create multiple part tables or import in single table or anyother step.


I am going to use sql server enterprise 2014. Thanks





Aucun commentaire:

Enregistrer un commentaire