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 » Internals » Updates   (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
  • 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