Migrate Off-Row LOB Data to In-Row Storage

Some data definition language (DDL) and utility operations that work on an entire table copy all table data by rewriting the data row to match that of the target schema.

There are several ways to convert LOBs to use in-row storage: You can migrate existing data using any of these methods, reducing space usage for the text pages and moving to in-row LOB storage.
Related concepts
In-Row LOB Columns and Bulk Copy