THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Updates » Performance   (RSS)
  • Halloween Protection – The Complete Series

    I have just published a four-part series for SQLPerformance.com on the Halloween Problem. Some of you will never have heard of this issue, and those that have might associate it only with T-SQL UPDATE queries. In fact, the Halloween problem affects execution plans for INSERT, UPDATE, DELETE and MERGE statements. This is a topic I have been ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on February 20, 2013
  • 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 when deleting rows causes them to expand before they can be deleted.  The mechanism at ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on August 30, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement