Re: Adding Fields to a large table

Marc,

They will take up 9 bytes each regardless of whether or not they are null.

-- Bill

"Marc" <Roger_Rombooth@xxxxxxxxxxxxxxxx> wrote in message
news:CB83237B-BDE4-467F-8C4B-AD9C88D972B5@xxxxxxxxxxxxxxxx
Dear all

I implemented a datawarehouse for a midsized retail company on SQL Server
2005. One of their facttables is a daily stock snapshot with about 50
millions of records.

Business now want to create a new report. This report requires several
calculated values. The requirement says this values should be stored in
the
warehouse.

Here is my question: When I add 3 more decimal fields (18,9) to this stock
table - how does this affect the size of the record/table when they have
NULL
values or a value?

Thanks in advance for your help,

Regards,

Marc




.

Relevant Pages

  • Re: MS Access Reports and VB.NET Program
    ... think that I want to ship a 30mb .NET framework to each of my clients? ... Barns & Noble has some books that could help you learn .NET. ... It is Access TIMES eCommerce TIMES Sql Server. ... that you actually posted how to execute the report using a macro. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: MS Access Reports and VB.NET Program
    ... It's not always about you Aaron. ... Barns & Noble has some books that could help you learn .NET. ... It is Access TIMES eCommerce TIMES Sql Server. ... that you actually posted how to execute the report using a macro. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: PRIMARY filegroup is full - no its not!
    ... Consider using sp_helpfile to report the sizes. ... Columnist, SQL Server Professional ... "Dan Guzman" wrote in message ... > large file size after I expand the file using "ALTER DATABASE DataLoad ...
    (microsoft.public.sqlserver.server)
  • Re: Project REAL webcast
    ... As an MSDN subscriber you can download CTP releases (which are coming out ... Both SQL Server Yukon and Visual ... And can the report builder run on 2000 as well without VS ... databases, SQL Server 2000 databases, and SQL Server 2005 Analysis Services ...
    (microsoft.public.sqlserver.olap)
  • Re: ldb file and Exclusive Access question
    ... Excel to report it. ... schedulable SQL server package. ... first db fro the 1st report I wanted to schedule. ... >database, the probability of database corruption is significantly increased. ...
    (comp.databases.ms-access)
Loading