SQL Server heap v.s. clustered index
Heap storage has nothing to do with these heaps. Heap just means records themselves are not ordered (i. e. not linked to one another). When you insert a record, it just gets inserted into the free space the database finds. Updating a row in a heap based table does not affect other records (though it … Read more