These pages are storages
the LOB (large object) data, technically data which is more than 8 KB in size.
It stores the data of data types (text, ntext, image, nvarchar (max), varchar
(max), varbinary (max), and xml).Data that has Row-Overflow Data Exceeding 8
KB, if the data is more than the size of the page (8KB) the data column will be
automatically allocated to the new page by sql server and will set IN_ROW_DATA
allocation counter to 1.
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Delay Validation Property is available on Task level, Connection Manager, Container and on Package level. By default the value of this pro... -
There are multiple ways to run the SSIS package. Refer my previous post where I explain the multiple ways to schedule our SSIS package. I... -
Suppose you have excel and in that excel we have a column that contains mixed data type (like number, date, string etc.). While we are try... -
The RecordSet destination does not save data to an external data source. Instead, the RecordSet destination saves data in memory in a Reco... -
The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way to join two data sources together. There ...
No comments:
Post a Comment
If you have any doubt, please let me know.