>Thanks for the reply Sergey. I am glad to hear that it works the same way as regular varbinary, does that mean there are no performance issues with varbinary(max)? (that you are aware of).

Hi Einar,

If value for varbinary(max) can be stored(fit) in the row than it'll be the same as regular varbinary. Otherwise it'll be stored separately with 16-byte pointer to it in the record.