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