Post reply

Number of pages associated with a table

  • January 31, 2013 at 4:03 am

    #394074

    Hi all experts,

    I am a newbie. Just for curiosity i would like to know the number of pages associated with a table?

    I would appreciate if you could post some relavent links to this question. 🙂

  • January 31, 2013 at 4:09 am

    #1582867

    Query sys.dm_db_partition_stats.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 31, 2013 at 5:11 am

    #1582893

    Hi Shadab,

    If your question is how many pages can you have in a table. Then,

    Microsoft claims that number of rows in a table is dependent on the available storage which means the size of table is also limited to the available storage.

    For the matter of fact, the granular level of storing data in database are pages. A page is of 8kb size.

    Now think like this, Table has Rows and Rows are stored as Pages. There is no max limit for number of pages other then table size.

    http://msdn.microsoft.com/en-us/library/ms143432.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply