SQL Server Access Methods
As Microsoft says: “Generally, there are different methods for accessing the data in each table. If only a […]
Daily Archives: April 1, 2018
SQL Server Gaps
What are gaps? Gaps and islands are classic challenges in T-SQL that involves a sequence of values. The […]
SQL Server Heap
Preliminary Information A table can be organized one of two ways: heap or B-tree. If a table has […]
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 Pages and Extents
The page is the fundamental unit of data storage in SQL Server. An extent is a collection of […]
SQL Server Internal Data Structures
As opposed to the logical query processing discussed in the post SQL Server Logical Query, we are now […]