Browse by Tags

Tagged Content List
  • Wiki Page: Dropping a Clustered Index Will Not Reorganize the Heap

    If a clustered index will be turned into a HEAP, no reorganization of the data will occur. This "myth" is sometimes popping up in forums or blogs. A view "behind the scenes" will describe how Microsoft SQL Server is handling this operation. Before the deep dive into the internals...
  • Wiki Page: SQL Server: No Fragmentation in HEAP from INSERT / UPDATE

    A HEAP won't be "fragmented" in two cases: - only INSERTS may occur - UPDATES will occur in the attributes with fixed data length (e.g. char ) The following example demonstrates the above mentioned situations: First a simple HEAP will be created: 01. USE tempdb; ...
Page 1 of 1 (2 items)
Can't find it? Write it!