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
    Honorary Member Highly Decorated Member Award 500 Likes Award

    BosonMichael Yottabyte Poster

    19,183
    500
    414
    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...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.