July 20, 2006 09:20 PM
Stretching the 8K Row Limit
Discover how SQL Server 2005 stores row-overflow data
Rating:

(0)
SQL Server Magazine
InstantDoc ID #50490
Over the last few months, I've discussed how SQL Server 2005 keeps track of
storage space that tables and indexes use and that the new metadata structures
are a bit more complex than those in SQL Server 2000, but also offer greater
flexibility. In "Managing Data Space," June 2006, InstantDoc ID 50009, I explain
that each table (or index) can have data stored in three different forms: regular
IN_ROW data, large object (LOB) data, and row-overflow (ROW_OVERFLOW) data,
which is ne...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: