How does MSSQL organize Record Data on disk in the database?

[Jane]

@CarlBarnes

I would guess most SQL store records by Primary Key so SET( File:PrimaryKey ) may be most efficient. Would be interesting if anyone knows?

MS SQL stores records by CLUSTERED index, which may or may not be the primary key. Tables that don’t have a clustered index are stored as “heaps”.