Maximum row count of given table in SQL 2008R2 spannign across filegroups RRS feed

  • Question

  • I understand that SQL server 64-bit systems have upper limit on the filegroups (32K) per database. Given that a table can span across multiple filegroups, is there an upper limit on the number of rows for the given table. 

    Or is it just limited by available storage?


    Tuesday, August 25, 2015 3:12 PM


  • `Hi Jagi,

    You can store N number of rows but it depends upon your harddisk space availability
     Try this link
    It states that the maximum rows per table is only limited by your available storage
    you have these limits
    columns in a table=246
    Bytes for each column=1024
    Total bytes in a table for each row=246*1024=251904bytes or 246 K bytes of one row.

    Please Dont forget to mark as answer and Helpful Post. It helps others to find relevant posts to the same question. Milan Das

    Tuesday, August 25, 2015 3:41 PM