Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
taylorshuman
Starting Member
1 Post |
 Posted - 2008-12-23 : 18:47:12
|
| TEXTPTR on a nvarchar(max) field returns a 16 byte pointer that points to the root structure of the B-tree containing the blocks of text data (according to BOL).However you don't need 16 bytes to point to a column of data, considering 8 bytes can address 16.8 million terabytes of data. Is part of the pointer the text data size? If so, which part?Thanks for any insight. |
|
|
|
|
|
Structure of a nvarchar(max) pointer