"Ragu" <ragudba@sbcglobal.net> wrote in message
news:vgToc.10890$TC5.2751@newssvr23.news.prodigy.com...
> 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
>
>
>

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:7empc.92$Mw2.5784667@news-text.cableinet.net...
> Hi
>
> Check out "Estimating the Size of a Database" in Books online:
>
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\cre
> atedb.chm::/cm_8_des_02_92k3.htm
>
>
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\cre
> atedb.chm::/cm_8_des_02_33js.htm
>
>
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\cre
> atedb.chm::/cm_8_des_02_2248.htm
>
>
> John
>
> "Ragu" <ragudba@sbcglobal.net> wrote in message
> news:vgToc.10890$TC5.2751@newssvr23.news.prodigy.com...
> > 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
> >
> >
> >
>
>

> 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.
> ...
> 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.