We are facing the task of storing of 0.5 TB of data in a SQL Server 2008 Server. Is it possible to do it in a standalone server? Later we also want to query for generating statistics of the data (a lot of group bys, inner joins, etc) but the database is so simple(1 big table & 3 very smalls). What you, experts, would recommend? Do you think we will get an acceptable query response?
The specifications of the server is:
- Dedicated one
- VMWare
- 2gb of RAM
- Xeon 2.13Ghz