Delaing with a large dataset

I have been given dataset (one is 6 db and the other is 35 gb). this is my first time to handle such large database, I have been used to small datasets (surveys), using STATA and SPSS.

My qestion is, what are the recommended data management systems for data management and analysis

I am also interested in automating some of the functions, like filter or rows/columns. I am good in programming using

Anthony MatovuBusiness Analyst, MTN UgandaAsked:
Who is Participating?
SQL Server has a nice suite of integrated tools with an obvious affinity to  It can handle well-designed DB's of that size without breaking a sweat.
hi MatovuAnthony

SQL server 2008 R2 can handle a database of size 524,272 terabytes
for more details check the link for the Maximum Capacity Specifications for SQL Server
and for dealing with large database using data-grid in VB
here you go you can use Virtual Mode with Just-In-Time Data Loading
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.