Search
SQL Server Home
DownloadsFeedbackSurveys
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 28 Previous 123 Next

13
0
Sign in
 to vote
MERGE Incorrectly Reports Unique Key Violations - by Paul White NZ
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 3 weeks ago) | 4 validations | 0 workarounds | 1 comment | feedback id: 773895  | 
Active
56
0
Sign in
 to vote
Cardinality Estimation Error With Pushed Predicate on a Lookup - by Paul White NZ
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 8 weeks ago) | 7 validations | 0 workarounds | 1 comment | feedback id: 767395  | 
Closed
as Won't Fix Help for as Won't Fix
7
0
Sign in
 to vote
Simple Parameterization on Partitioned Tables Disables Partition Elimination - by Paul White NZ
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 4 weeks ago) | 2 validations | 1 workaround | 3 comments | feedback id: 762219  | 
Resolved
as Won't Fix Help for as Won't Fix
29
0
Sign in
 to vote
UPDATE STATISTICS Does Not Cause Recompilation for a Cached Temporary Table - by Paul White NZ
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 3 weeks ago) | 7 validations | 0 workarounds | 9 comments | feedback id: 758241  | 
Closed
as Won't Fix Help for as Won't Fix
4
0
Sign in
 to vote
DBCC checks are inconsistent for denormal floating-point values - by Paul White NZ
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 31 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 752245  | 
Closed
as Duplicate Help for as Duplicate
3
0
Sign in
 to vote
Partitioned Table Seek Incorrect Costing - by Paul White NZ
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 4 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 750169  | 
Resolved
as Won't Fix Help for as Won't Fix
32
0
Sign in
 to vote
Poor Performance with Parallelism and Top - by Paul White NZ
From Connection: SQL Server
In SQL Server 2008 onward, a parallel plan that includes a final TOP in a serial zone may exhibit very poor performance at DOP > 2. The early end to processing signalled by the TOP may not be honoure…
Created on 5/2/2012 (updated 1 week ago) | 9 validations | 0 workarounds | 4 comments | feedback id: 740234  | 
Resolved
as Won't Fix Help for as Won't Fix
4
0
Sign in
 to vote
COALESCE documentation bug - by Paul White NZ
From Connection: SQL Server
The COALESCE (Transact-SQL) topic [http://msdn.microsoft.com/en-us/library/ms190349(v=sql.110).aspx] contains this in the Remarks section: ISNULL and COALESCE though equivalent, can behave differentl…
Created on 3/13/2012 (updated 23 weeks ago) | 1 validation | 0 workarounds | 3 comments | feedback id: 731028  | 
Active
4
0
Sign in
 to vote
Plan Regression with Sequence Projections - by Paul White NZ
From Connection: SQL Server
In SQL Server 2008, the optimizer is able to push suitable predicates below a sequence project. In 2008 R2, pushing selections is broken for sequence projections that require a segment apply, namely …
Created on 2/29/2012 (updated 2 days ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 727419  | 
Active
15
0
Sign in
 to vote
Costing & Cardinality Errors with Partial Aggregates in Serial Execution Plans - by Paul White NZ
From Connection: SQL Server
The following Adventure Works query generates a plan with a partial aggregate in a serial execution plan (cost threshold for parallelism at the default value of 5): SELECT COUNT_BIG(*) FROM Produ…
Created on 12/5/2011 (updated 3 weeks ago) | 2 validations | 0 workarounds | 2 comments | feedback id: 711685  | 
Active
Showing 1 - 10 of 28 Previous 123 Next





© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement