Sql Server Sizing Planning - Architecture Help

Hi

I joined a project where 100,000 rows were added everyday. Now due to
additional customers the expectation is 2 million reocrds/day ie 10 GB worth
of textfiles. We have to estimate the hard disk, memory, # of CPUs etc.We
will have one yearworth of data in the db. Rest will be in tapes etc.

We will be using WIN2000, SQL Server2000.- Any comparable server sizing will
be appreciated.

1. Tohandle every day load, I thought that we will have a table for each day
(pre created in the database )and have a view with union all selecting
fromall these 365 tables. (This is the only way to partition in MSSQL Server
right?).

2. The requirement is to populate datawarehouse tables with all the data.
However there will be only inserts mostly but there can be updates too which
happenned in the past 12 days.Hence we have to use the data from the last
12 days and massage it etc and populate into datawarehouse tables.

How can I do this so that I will have the datawarehouse tables with n-12
days of data and I will alwys add the last 12 days data to it.

Do you have any suggestions?

Ragu