maximum row size in SQL Server

  • In SQL Server 2000 the maximum row size was 8060 bytes. 

    Has this changed in 2005?  I've been using the April CTP

    and I don't get warning messages anymore.



  • SQL Server 2005 introduces the concept of allocation units for data storage. Each partition (tables and indexes now consist of one or more partitions) has up to three allocation units (or IAM chains), depending on what features it uses. The first is for normal in-row data, which is essentially the same as any table in earlier versions. The next one is for LOB data, which is data stored in text, ntext or image columns, or the new large value types of course. The third is for storing row-overflow data. This is what we get when there are several varying size fields on a table that if they are filled up too much cause the total size of a row to exceed the ~8060 bytes that can fit in in-row data.

    See my blog for more info on support for large rows and partitions and allocation units.

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

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