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.
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.
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.
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).
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.