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

2
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 4 weeks ago) | 0 validations | 0 workarounds | 2 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 35 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 2 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 816739  | 
Closed
as Duplicate Help for as Duplicate
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 43 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 2 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 809771  | 
Closed
as Fixed Help for as Fixed
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 48 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 2 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 795491  | 
Closed
as Won't Fix Help for as Won't Fix
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 83 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 67 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 2 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 774632  | 
Closed
as Fixed Help for as Fixed
Showing 1 - 10 of 30 Previous 123 Next