Home Dashboard Directory Help
Refine Search Results
Status
Votes
Total Votes (at least)
Workarounds
Total Workarounds (at least)
Validations
Total Validations (at least)
Comments
Total Comments (at least)
Time
Created in the last (days)
Updated in the last (days)
Product Search Results
Sort By:
You searched for: items submitted by Paul White NZ for this product (signing in could show even more results)
Showing 1 - 10 of 37 Previous 123 Next

9
0
Sign in
to vote
From Connection: SQL Server
In SQL Server 2008 R2 and earlier, SQL Server can reorder concatenation inputs when a single-row row goal is present. This useful ability seems to have been removed for 2012 and later, without bein…
Created on 5/11/2017 (updated 2 days ago) | 2 validations | 0 workarounds | 0 comments | feedback id: 3134076  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
SQL Server generates an incorrect execution plan for: DECLARE @T table ( Col1 uniqueidentifier NOT NULL, Col2 AS NULLIF(Col1, Col1) PERSISTED -- Logically always NULL ); INSERT @T (Col1)…
Created on 5/2/2017 (updated 3 weeks ago) | 2 validations | 0 workarounds | 0 comments | feedback id: 3133359  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
A query plan that includes a (batch mode) Window Aggregate computing count(*) or count_big(*) does not populate Defined Values for the expression. The occurs whether the count is written explicitly, …
Created on 11/16/2016 (updated 27 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 3111677  | 
Active
7
0
Sign in
to vote
From Connection: SQL Server
The query in the Steps to Reproduce section below produces an execution plan with an unnecessary Eager Table Spool for Halloween Protection, but only when a parallel plan is generated. Adding a MAXDOP…
Created on 9/17/2014 (updated 76 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 973964  | 
Active
7
0
Sign in
to vote
Unnecessary Sort - by Paul White NZ
From Connection: SQL Server
The following AdventureWorks query plan includes an unnecessary final sort: SELECT TransactionID FROM Production.TransactionHistory AS TH2 WHERE ProductID = 784 OR TransactionID BETWEEN 100026 AND 1…
Created on 7/25/2014 (updated 48 weeks ago) | 1 validation | 2 workarounds | 3 comments | feedback id: 928733  | 
Resolved
as Fixed Help for as Fixed
33
0
Sign in
to vote
From Connection: SQL Server
Both "old" and "new" cardinality estimators produce an incorrect estimate for an apply semi join with predicates pushed below a union all on the inner side. The incorrect estimate is a fixed 100% of …
Created on 6/26/2014 (updated 2 weeks ago) | 6 validations | 0 workarounds | 0 comments | feedback id: 906783  | 
Active
39
0
Sign in
to vote
From Connection: SQL Server
A delete statement using a nonclustered index to locate rows to delete can be adversely affected by the addition of an unrelated filtered index. See the script at http://pastebin.com/cbqXGHX4 for the …
Created on 6/1/2014 (updated 33 weeks ago) | 7 validations | 0 workarounds | 2 comments | feedback id: 885744  | 
Active
6
0
Sign in
to vote
From Connection: SQL Server
Using AdventureWorks, the following query includes a perfect correlation between two conjunctive predicates. The query returns 69 rows. -- Assuming independence, the cardinality estimate is one row i…
Created on 9/22/2013 (updated 27 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 801908  | 
Closed
as By Design Help for as By Design
69
0
Sign in
to vote
From Connection: SQL Server
SQL Server can produce incorrect results when reading from a partitioned non-unique nonclustered index with a descending leading key. The provided script demonstrates the issue with a simple seek, bu…
Created on 8/20/2013 (updated 174 weeks ago) | 10 validations | 1 workaround | 4 comments | feedback id: 797837  | 
Closed
as Fixed Help for as Fixed
32
0
Sign in
to vote
From Connection: SQL Server
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 colum…
Created on 12/9/2012 (updated 9 weeks ago) | 10 validations | 1 workaround | 7 comments | feedback id: 773895  | 
Closed
as Won't Fix Help for as Won't Fix
Showing 1 - 10 of 37 Previous 123 Next