Browse by Tags

• Deletes
• Query Plans
• Updates

• Deletes that Split Pages and Forwarded Ghosts

  Can DELETE operations cause pages to split?  Yes.  It sounds counter-intuitive on the face of it; deleting rows frees up space on a page, and page splitting occurs when a page needs additional space.  Nevertheless, there are circumstances Read More... Posted Friday, August 31, 2012 6:09 AM by Paul White | 11 Comments Filed under: Deletes, Page Splits, Performance, Undocumented, Updates

• Can a SELECT query cause page splits?

  Books Online has this to say about page splits: When a new row is added to a full index page , the Database Engine moves approximately half the rows to a new page to make room for the new row.  This reorganization is known as a page split .  Read More... Posted Tuesday, August 30, 2011 7:46 AM by Paul White | 6 Comments Filed under: Page Splits, Performance, Query Plans, Undocumented