"Dally" <ola.alli@acis-cam.uk.com> wrote in message
news:0cab01c34adf$3a6a6700$a401280a@phx.gbl...
> Hi,
>
> How do you calculate storage space for about 4 millions
> records in a data warehouse
>
> Regards
>
> Dally

<nntp> wrote in message news:uTBUYAxSDHA.1572@TK2MSFTNGP12.phx.gbl...
> The most accurate method I have found is to create a blank table, put a
> reasonable amount of rows in it, add all the indexes, do DBCC
UPDATEUSAGE(0)
> and the run sp_spaceused 'tablename'.
>
>
> "Dally" <ola.alli@acis-cam.uk.com> wrote in message
> news:0cab01c34adf$3a6a6700$a401280a@phx.gbl...
> > Hi,
> >
> > How do you calculate storage space for about 4 millions
> > records in a data warehouse
> >
> > Regards
> >
> > Dally
>
>