1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

70-431 - Calculating Table Space

Discussion in 'SQL Exams' started by ntfirewall, Jun 24, 2009.

  1. ntfirewall

    ntfirewall New Member

    I am preparing from various books, and each has different formulas. Basically i want to know how to calculate space required for a table with a clustered index and a table with non clustered index.

    I use the following formula to calculate table size

    row_size = fixed+variable+null_bitmap+4
    null_bitmap = 2+(no of columns + 7 )/8)
    rows per page = 8096 / row size

    total pages = total rows in table / ows per page
    then 8192 * total pages to give me total size

    in some examples i have seen that in calculating row size the header size is ignored (fixed+variable+null_bitmap)

    could any one please clear these formulas for me

  2. BosonMichael
    Highly Decorated Member Award

    BosonMichael Yottabyte Poster

    They probably have different formulae because every DBS calculates differently.
    Certifications: CISSP, MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CCNA Security, CCNA Voice, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
    WIP: Just about everything!

Share This Page