SQL Server Internal Data Structures
As opposed to the logical query processing discussed in the post SQL Server Logical Query, we are now […]
Series: SQL Server Data Structures
SQL Server Pages and Extents
The page is the fundamental unit of data storage in SQL Server. An extent is a collection of […]
SQL Server B-Tree
When you think of B-trees, think “clustered index”. All indexes in SQL Server on disk-based tables are structured […]
SQL Server Heap
Preliminary Information A table can be organized one of two ways: heap or B-tree. If a table has […]
SQL Server Access Methods
As Microsoft says: “Generally, there are different methods for accessing the data in each table. If only a […]