Printed 2016/05/27 01:10AM

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 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-2016 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.