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 39 Previous 123 Next

6
0
Sign in
to vote
From Connection: SQL Server
The repro shown in the Steps to Reproduce section below produces: Transaction was deadlocked on generic waitable object resources with another process and has been chosen as the deadlock victim. …
Created on 7/7/2017 (updated 1 week ago) | 3 validations | 0 workarounds | 0 comments | feedback id: 3137160  | 
Resolved
as Fixed Help for as Fixed
3
0
Sign in
to vote
From Connection: SQL Server
SSMS 17.1 Install Fails with Error 0x80070643 if Internet Explorer 11 is not installed. Log extract: [1CE4:10B4][2017-05-30T19:32:15]i000: MainViewModel.OnPackageActionProgress: Percent completed: 1…
Created on 5/30/2017 (updated 3 weeks ago) | 2 validations | 0 workarounds | 4 comments | feedback id: 3134985  | 
Active
11
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 1 week ago) | 2 validations | 0 workarounds | 3 comments | feedback id: 3134076  | 
Resolved
as Fixed Help for as Fixed
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 10 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 39 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 88 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 60 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 14 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 45 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 39 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 801908  | 
Closed
as By Design Help for as By Design
Showing 1 - 10 of 39 Previous 123 Next