Data-Row Format and Storage
The variable length of a data row has the following consequences
for row storage:
- A page might contain one or more whole rows.
- A page might contain portions of one or more rows.
- A page might contain a combination of whole rows and partial rows.
- An updated row might increase in size and become too long to return to its original storage location in a row.
The following paragraphs describe the guidelines that the database server follows during data storage.