Home Dashboard Directory Help
Search
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 32 Previous 123 Next

7
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 6 hours ago) | 3 validations | 0 workarounds | 0 comments | feedback id: 906783  | 
Active
16
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 5 days 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 1 week 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 25 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 1 week 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 31 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 64 weeks ago) | 2 validations | 1 workaround | 3 comments | feedback id: 762219  | 
Resolved
as Won't Fix Help for as Won't Fix
33
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 10 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 92 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 752245  | 
Closed
as Duplicate Help for as Duplicate
3
0
Sign in
to vote
From Connection: SQL Server
An index seek into a partitioned table on the inner side of a correlated nested loops join is incorrectly costed as if it touches every partition, where dynamic elimination is achieved via an outer re…
Created on 6/20/2012 (updated 64 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 750169  | 
Resolved
as Won't Fix Help for as Won't Fix
Showing 1 - 10 of 32 Previous 123 Next