I have a SQL Server 2005 database. It’s .MDF & .LDF can
be downloaded at https://www.dropbox.com/s/uj2mw410jm2m078/MyDB.rar?dl=0
Now I want to know whether two table are stored as heap or
b-tree(linked list), so I run the following commands:
from sys.objects, sys.partitions,
where (sys.partitions.object_id = sys.objects.object_id) and
((name = 'cardfa') or (name = 'pcspkc'));
Where 'cardfa' and 'pcspkc' are the two user tables I want
The result is below:
both table’s index_id is 1, they are all stored as b-tree(linked list).
However, with the help of DBCC Page command, I find the 'cardfa' table is
actually stored in heap, which is inconsistent with the search result. Why?