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

    1
    0
    1
    Hello
    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

    thanks
     
  2. BosonMichael
    Highly Decorated Member Award

    BosonMichael Yottabyte Poster

    19,136
    462
    374
    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

Loading...