http://www.sqlservercentral.com/blogs/sqlserverzestcom-sql-in-simple-style/2013/10/14/sql-server-understanding-allocation-units-in-row-data-lob-data-row-overflow-data/

Printed 2014/11/23 07:51AM

SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data

By VS Raavi, 2013/10/14

Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard limit on the data that can be stored in a single row, which is 8,060 bytes. So, if the data exceeds this limit, the update or insert operation would fail! Fortunately, in later SQL Server […]
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.