Tag: Index

• B+Trees – How SQL Server Indexes are Stored on Disk

  

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

  How does SQL Server organize clustered and non-clustered indexes on disk? SQL server uses B+Trees. Read on to find out what B+Trees are and how they are implemented in SQL Server.

  [more…]

• The Page Header (A Storage Wednesday Post)

  

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

  SQL Server organizes databases in chunks of 8192 bytes, called pages. Each page starts out with 96 byte of meta-information – the page header. Read on to see what kind of information is stored in this special area.

  [more…]