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 33 Previous 123 Next

6
0
Sign in
to vote
From Connection: SQL Server
See repro below (from http://dba.stackexchange.com/q/124655/3690). The Anti Semi join in the plan appears to incorrectly join on [GeodeticTessellation].Id instead of the base table column Id leading …
Created on 12/28/2015 (updated 25 weeks ago) | 5 validations | 1 workaround | 0 comments | feedback id: 2178150  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Publishing an SSDT project fails against an existing database under the following conditions. 1. A scalar UDF with schema binding references an object that is being updated. 2. The scalar UDF cont…
Created on 9/14/2015 (updated 41 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 1788858  | 
Active
2
0
Sign in
to vote
From Connection: SQL Server
This happens to me at least once a week throughout multiple versions of SSDT (currently on SQL Server Data Tools 12.0.50318.0). Together with frequent crashes because of this issue https://connect…
Created on 7/28/2015 (updated 33 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 1600594  | 
Active
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 85 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 973998  | 
Closed
as Fixed Help for as Fixed
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 38 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 824193  | 
Closed
as By Design Help for as By Design
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 88 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 129 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 88 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 809771  | 
Closed
as Fixed Help for as Fixed
5
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 77 weeks ago) | 3 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 88 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 795491  | 
Closed
as Won't Fix Help for as Won't Fix
Showing 1 - 10 of 33 Previous 123 Next