Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    30

    Question Unanswered: What is the Maximum Row sizein SQL server.

    Hello to all

    # I want to know that What is the Maximum Row size in SQL server ?

    # Maximum limit of storing rows in table ?

  2. #2
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Max row size depends on a few things. If it includes VARBINARY columns then the maximum per row is multiple gigabytes. If it includes FILESTREAM then there's no limit except the OS and disk.

    There is no documented limit on the number of rows per table. It should be limited only by the maximum database size, which is apparently 524,272 terabytes - not that I've tested it myself.

    Maximum Capacity Specifications for SQL Server

  3. #3
    Join Date
    Apr 2009
    Posts
    30
    Hello dportas !

    Thanks for reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •