I am a developer reading the book "Querying Microsoft SQL Server 2012." I have come across the following diagram:
Why are the pages in the first two rows of the diagram (row 1 starting:
1:174
and row 2 starting:1:41
) not part of an extent? The documentation says: "all pages are stored in extents":How does the number scheme work e.g. what does
1:174
mean?Directly above the diagram, the book says: "IAM pages for an object are organized as a doubly linked list;" The diagram does not show any links between the pages.