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

1
0
Sign in
to vote
From Connection: SQL Server
It is valid to delete from an inline TVF and use the OUTPUT clause. The statement works in SQL Server but crashes the SSDT project.
Created on 9/17/2014 (updated 1 day ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 973998  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
This was something I noticed when looking at https://connect.microsoft.com/SQLServer/feedback/details/822931/query-optimizer-doesnt-understand-how-to-optimize-rollup But I thought posting it as a s…
Created on 2/26/2014 (updated 29 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 824193  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
In a database with RCSI enabled a batch that does the following (as auto commit transactions) 1. Declares an instance of a memory-optimized table type. 2. Inserts a row to the above. 3. Joins it to a…
Created on 2/5/2014 (updated 31 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 816739  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
For estimated plans that contain multiple statements if a missing index benefits more than one statement it appears that the impact from the first is displayed next to all of them. The issue does not …
Created on 1/3/2014 (updated 36 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 812880  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
The article http://msdn.microsoft.com/en-us/library/ms190439.aspx contains the line " But adding a new index from which the procedure might benefit does not cause automatic recompilation because the…
Created on 11/26/2013 (updated 27 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 809771  | 
Active
3
0
Sign in
to vote
From Connection: SQL Server
In some circumstances a session can get caught in a situation where it starts up a droptemp transaction, is blocked by itself, rolls back and repeats the process ad infinitum. Originally found here h…
Created on 11/24/2013 (updated 42 weeks ago) | 2 validations | 0 workarounds | 0 comments | feedback id: 809544  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
I suppose this is a bug so have reported it. The reason I came across the issue was because I wondered if using this syntax would avoid the need to use CONVERT with a style parameter for datetime l…
Created on 7/31/2013 (updated 59 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 795491  | 
Active
4
0
Sign in
to vote
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 77 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
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 61 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 775598  | 
Closed
1
0
Sign in
to vote
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 57 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 774632  | 
Active
Showing 1 - 10 of 30 Previous 123 Next