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

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 4 weeks ago) | 1 validation | 2 workarounds | 0 comments | feedback id: 928733  | 
Active
14
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 t…
Created on 6/26/2014 (updated 1 day ago) | 3 validations | 0 workarounds | 0 comments | feedback id: 906783  | 
Active
17
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 4 weeks ago) | 6 validations | 0 workarounds | 0 comments | feedback id: 885744  | 
Active
4
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 6 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 801908  | 
Active
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 31 weeks ago) | 10 validations | 1 workaround | 4 comments | feedback id: 797837  | 
Closed
as Fixed Help for as Fixed
19
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 6 weeks ago) | 8 validations | 0 workarounds | 3 comments | feedback id: 773895  | 
Active
60
0
Sign in
to vote
From Connection: SQL Server
In SQL Server 2005, a filtering condition on a column retrieved from a Key Lookup is applied in an explicit Filter operator after an apply join. In SQL Server 2008 onward, this filter can be pushed d…
Created on 10/14/2012 (updated 36 weeks ago) | 8 validations | 0 workarounds | 2 comments | feedback id: 767395  | 
Closed
as Won't Fix Help for as Won't Fix
7
0
Sign in
to vote
From Connection: SQL Server
Simple parameterization of a char column that is the partitioning column for a table prevents partition elimination when a literal value is used in a predicate on that column, unless an explicit cast …
Created on 9/11/2012 (updated 70 weeks ago) | 2 validations | 1 workaround | 3 comments | feedback id: 762219  | 
Resolved
as Won't Fix Help for as Won't Fix
34
0
Sign in
to vote
From Connection: SQL Server
Based on my post at bit.ly/TempTables: When a temporary table in a stored procedure is cached, any statistics created by AutoStats are also cached. This leads to odd effects when a query in the proc…
Created on 8/15/2012 (updated 4 weeks ago) | 8 validations | 0 workarounds | 10 comments | feedback id: 758241  | 
Closed
as Won't Fix Help for as Won't Fix
4
0
Sign in
to vote
From Connection: SQL Server
DBCC CHECKTABLE raises a consistency error for denormal REAL values, but not denormal FLOAT values. CREATE TABLE dbo.TestRealDenormal (col1 real NULL); CREATE TABLE dbo.TestFloatDenormal (col1 float …
Created on 7/3/2012 (updated 97 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 752245  | 
Closed
as Duplicate Help for as Duplicate
Showing 1 - 10 of 33 Previous 123 Next