Tag: LOB

• Hey, where is my BLOB?

  

  2014-08-13 - General, Series, SQL Server Internals, Storage Wednesday

  LOB values are not always stored in the special LOB_DATA allocation unit. But, where else could they be? Discover the well-kept secret of the Inline LOB.

  [more…]

• How to Overflow a BLOB Value

  

  2014-08-06 - General, Series, SQL Server Internals, Storage Wednesday

  It is advertised as 2 GB, but what is actually the largest number of bytes that can be stored in a SQL Server BLOB value? Read on to find out now.

  [more…]

• Page Type 4 – The Mysterious TEXT_TREE_PAGE

  

  2014-07-30 - General, Series, SQL Server Internals, Storage Wednesday

  What purpose have pages of type TEXT_TREE_PAGE? Discover how SQL Server uses these pages to build positional B+Tree indexes on large LOB values.

  [more…]