Working with a client, I came across some stored procedures that went through gyrations to selectively store XML in a varchar field or in a text field, depending on its size. But, after doing a little research, I came across this article on SQL blob storage with the following key points
- blobs are text, ntext, or image fields
- blobs are stored in a separate heap of 8KB pages
- blobs can be stored “in row” if the feature is turned on and the size is below the configurable limit
- blob pointers take up 16 bytes when the blob is not stored in-row
Recent Comments