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

[Rick_UpperPark]

@CarlBarnes

I would guess most SQL store records by Primary Key so SET( File:PrimaryKey ) may be most efficient

If the primary key is the clustered key, then this would be fastest. However, without using BUFFER so you reduce the number of calls to the server to return the result set, it will still be slow with a large number of rows. Using BUFFER with the file or a VIEW will greatly reduce the time required by returning a larger number of rows at a time from the server.