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 Martin Smith for this product (signing in could show even more results)
Showing 1 - 10 of 23 Previous 123 Next

4
0
Sign in
 to vote
Incorrect / Inconsistent results for CROSS APPLY (SELECT TOP X PERCENT ... ) - by Martin Smith
From Connection: SQL Server
For the query SELECT x.* FROM T1 org CROSS APPLY (SELECT TOP (50) PERCENT * FROM T2 WHERE OrganizationID = org.OrganizationID) x; the results dif…
Created on 2/1/2013 (updated 7 weeks ago) | 0 validations | 1 workaround | 4 comments | feedback id: 778200  | 
Closed
as By Design Help for as By Design
1
0
Sign in
 to vote
varchar(max) in FK constraint? CREATE TABLE topic on BOL - by Martin Smith
From Connection: SQL Server
From http://msdn.microsoft.com/en-us/library/ms174979.aspx "A column of type varchar(max) can participate in a FOREIGN KEY constraint only if the primary key it references is also defined as type var…
Created on 1/2/2013 (updated 19 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 775598  | 
Active
1
0
Sign in
 to vote
"ANSI NULL Default" documentation confusing - by Martin Smith
From Connection: SQL Server
From http://msdn.microsoft.com/en-us/library/ms188124.aspx ANSI NULL Default Specify the default behavior of the Equals (=) and Not Equal To (<>) comparison operators when used with null values. Pos…
Created on 12/18/2012 (updated 20 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 774632  | 
Active
1
0
Sign in
 to vote
Documentation for ALTER TABLE ... ALTER COLUMN restrictions needs reviewing? - by Martin Smith
From Connection: SQL Server
The documentation here http://msdn.microsoft.com/en-us/library/ms190273.aspx indicates various restrictions for ALTER TABLE ... ALTER COLUMN including the following. The modified column cannot be ...…
Created on 10/20/2012 (updated 29 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 768134  | 
Active
3
0
Sign in
 to vote
Odd behaviour of SCOPE_IDENTITY with INSERT INTO ... OUTPUT ... INTO - by Martin Smith
From Connection: SQL Server
Repro has three different queries of the following form insert into #t output inserted.a into #inserted_into values ('a'),('b'); select scope_identity() If only #t has an IDENTITY column defined …
Created on 10/2/2012 (updated 11 weeks ago) | 1 validation | 0 workarounds | 2 comments | feedback id: 765809  | 
Closed
as Won't Fix Help for as Won't Fix
1
0
Sign in
 to vote
Grammar for `SET FIPS_FLAGGER` incorrect in BOL - by Martin Smith
From Connection: SQL Server
The documentation here http://msdn.microsoft.com/en-us/library/ms189781.aspx gives the syntax SET FIPS_FLAGGER 'level' It should presumably be SET FIPS_FLAGGER ( 'level' | OFF ) I spent a small…
Created on 9/28/2012 (updated 31 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 765187  | 
Closed
as Fixed Help for as Fixed
4
0
Sign in
 to vote
Statistics estimation for LIKE on columns with trailing spaces can be very wrong. - by Martin Smith
From Connection: SQL Server
Repro shows an example where 100% of the table rows match a predicate, the statistics are updated with full scan and accurate but the estimated number of matching rows is orders of magnitude too small…
Created on 9/17/2012 (updated 34 weeks ago) | 2 validations | 0 workarounds | 3 comments | feedback id: 763060  | 
Active
1
0
Sign in
 to vote
Multistatement TVF referenced in CASE statement called unnecessarily - by Martin Smith
From Connection: SQL Server
BOL Currently states "You should only depend on order of evaluation of the WHEN conditions for scalar expressions (including non-correlated sub-queries that return scalars), not for aggregate expressi…
Created on 7/9/2012 (updated 3 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 752873  | 
Closed
as Won't Fix Help for as Won't Fix
2
0
Sign in
 to vote
Documentation incorrect for sys.dm_exec_plan_attributes.user_id - by Martin Smith
From Connection: SQL Server
The documentation (http://technet.microsoft.com/en-us/library/ms189472.aspx) says for user_id Value of -2 indicates that the batch submitted does not depend on implicit name resolution and can be sh…
Created on 6/4/2012 (updated 1 week ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 746261  | 
Active
1
0
Sign in
 to vote
Pattern syntax undocumented difference in behaviour between varchar vs nvarchar - by Martin Smith
From Connection: SQL Server
SELECT PATINDEX('%[a-]%', N'aaa-def' COLLATE Latin1_General_BIN), PATINDEX('%[-a]%', N'aaa-def' COLLATE Latin1_General_BIN), PATINDEX('%[a-]%', 'aaa-def' COLLATE Latin1_General_BIN), …
Created on 5/20/2012 (updated 18 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 742841  | 
Closed
as Won't Fix Help for as Won't Fix
Showing 1 - 10 of 23 Previous 123 Next





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