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   (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
  • 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
  • How to Install Master Data Services (MDS) Service Pack 1 (for SQL Server 2008 R2)

    [This post was created by Jason Howell, Senior Escalation Engineer in the SQL Server Support team specializing in MDS] SQL Server 2008 R2 Service pack 1 was released in July 2011, as well as CU#1 for Service Pack 1 a few days afterwards, and CU #2 just yesterday August 15th, 2011. The purpose of this blog is to call out the difference in ...
    Posted to Master Data Services Team (Weblog) by mattande on August 16, 2011
  • SQL Server 2005 SP4 is here!

    Yes, the day has finally arrived, and a couple of weeks ahead of schedule.  Typically when Microsoft promises a release in Qx or Hx, the software comes on the last or second last day of that quarter or half.  This year, we get an early Christmas present: SQL Server 2005 SP4.   Downloads To download SP4, go to this ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 17, 2010
  • Downloading and Installing SQL Server 2008 R2 Master Data Services (MDS) Cumulative Updates

    (This post was contributed by Reagan Templin, Lead Technical Writer for the MDS Team) Note: This article is applicable to Microsoft SQL Server 2008 R2 Master Data Services feature. SQL Server 2012 now ships Master Data Services on the DVD with the other SQL Server 2012 features and is patched by the same Cumulative Updates and Service Packs for ...
    Posted to Master Data Services Team (Weblog) by mattande on August 25, 2010
  • 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