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 » Undocumented   (RSS)
  • Optimizing T-SQL queries that change data

    Most tuning efforts for data-changing operations concentrate on the SELECT side of the query plan. Sometimes people will also look at important storage engine considerations like locking and transaction log throughput that can have dramatic effects. As a consequence, a number of common practices have emerged, such as avoiding large numbers of ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on January 25, 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
  • The Impact of Non-Updating Updates

    From time to time, I encounter a system design that always issues an UPDATE against the database after a user has finished working with a record – without checking to see if any of the data was in fact altered.  The prevailing wisdom seems to be that “the database will sort it out”.  This raises an interesting question: how smart is SQL ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on August 10, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement