Tag: page

• 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…]

• 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…]

• Page Type 3 – LOB Data Pages explained

  

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

  LOB data values in SQL Server are stored in separate allocation units in pages of type TEXT_MIX_PAGE. Read on and discover when these pages are used and how you can find out if your tables contain any pages of that type.

  [more…]

• The sys.dm_db_database_page_allocations DMF

  

  2014-07-09 - General, Series, SQL Server 2012, SQL Server Internals, Storage Wednesday

  Are you looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a particular table (or even all tables in a database).

  [more…]

• Intermediate Index Pages in SQL Server

  

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

  SQL Server stores indexes in B+ Tree format on disk. Each node is represented by a SQL Server page. The actual rows are stored in data pages while the index structure resides in intermediate index pages. Read on to find out more.

  [more…]