Problem:
SQL Server will allow a max row size of 8060 bytes. But, If i am having a table with column "Description" as Varchar(max). Since, Max keyword allows 2 GB of data. How my table row will react to store the data?
Solution:
The data will be stored as off-row values. It's stored upto a limit of 8060 bytes and this LOB will act as a root node with two child pointers,
1. One pointing to the data stored in 8060 bytes.
2. Other pointing to the location where the remaining datas are stored.
Happy Learning!!!
Regards,
Venkatesan Prabu . J
No comments:
Post a Comment