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 » Bugs » Merge   (RSS)
  • Incorrect Results with Indexed Views

    Summary: If you use MERGE, indexed views and foreign keys, your queries can return incorrect results. Microsoft have released a fix for incorrect results returned when querying an indexed view. The problem applies to: SQL Server 2012 SQL Server 2008 R2 SQL Server 2008 The Knowledge Base article does not go into much detail, or ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on February 5, 2013
  • MERGE Bug with Filtered Indexes

    A MERGE statement can fail, and incorrectly report a unique key violation when: The target table uses a unique filtered index; and No key column of the filtered index is updated; and A column from the filtering condition is updated; and Transient key violations are possible Example Tables Say we have ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on December 9, 2012
  • An Interesting MERGE Bug

    Summary: Investigating an optimiser transformation that exposes a bug in SQL Server’s MERGE implementation. I came across a Connect item today (by fellow SQL Server Central member ‘ALZDBA’) describing how using a combination of relatively new features can produce incorrect results or even an access violation inside SQL Server. Reproducing the ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on August 3, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement