2007.09.03

SQL Blob Storage

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