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   (RSS)
Showing page 1 of 2 (12 total posts)
  • Incorrect Results Caused By Adding an Index

    It’s not often that a SQL Server bug really surprises me or makes me wonder how it was never spotted before, but this is one of those. To get right into it, say you have the following two tables: CREATE PARTITION FUNCTION PF (integer) AS RANGE RIGHT FOR VALUES (1000, 2000, 3000, 4000, 5000);   ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on August 20, 2013
  • 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
  • Cardinality Estimation Bug with Lookups

    Estimated row counts on key or RID lookups where a filtering predicate is applied can be wrong in SSMS execution plans.  This error does not affect the optimizer’s ultimate plan selection, but it does look odd.  There are other cases where estimated row counts are inconsistent (for defensible reasons) but the behaviour shown in this post ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on October 15, 2012
  • Connect Digest : 2011-12-20

    Make SSMS start faster A couple of years ago, I blogged about some ways to make Management Studio start faster. With the latest builds of SQL Server 2012, it seems to be slower than ever, at least when starting SSMS for the first time after a reboot or install. So I've asked for them to do something in the background on Windows start-up ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 20, 2011
  • Want your bug fixed? File a good bug!

    In some circles I'm known as ''the Connect guy'' because I've filed a heck of a lot of suggestions and bugs that I've envisioned or encountered, and I'm often willing to file an issue on someone else's behalf. In other circles, for very much the same reasons, I'm probably known as ''that annoying Connect guy.'' On and off over the past few years, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 20, 2011
  • Connect Digest : 2011-04-25

    I wanted to change it up a little this week. In every digest, I've pointed out a set of Connect items that I believe deserve more attention. What I fail to point out every week is the number of Connect items that actually get resolved with a fix. These are even less visible than the active requests, but I think they deserve some attention as well. ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 25, 2011
  • A better way to search Connect

    I recently spotted a comment from Microsoft on a Connect item with 13 total up-votes.  The comment went something like, ''wow, due to the explosive response to this issue, we're going to deal with it right away.''  Okay, it wasn't that emphatic, it was actually: ''I've brought the MVP customer vote count to the attention of dev, and a ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 6, 2011
  • 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
  • SSMS : Which parts do you love? Which parts do you hate?

    I find myself categorizing a subset of SSMS features ranging from ''must have'' features to ''cringe when they are mentioned.''  I'll try to summarize the standouts for you here, then ask you these questions: Which parts of SSMS do you rely on? Which do you wish were not there at all? The ''I almost always use it to get the task done.'' ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 22, 2010
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement