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: merge (signing in could show even more results)
Showing 1 - 10 of 363 Previous 123 Next

1
0
Sign in
to vote
From Connection: SQL Server
During MERGE statement execution one can observe that X lock placed on the object after IX lock has been already placed on the object by the same process. Such locking behavior provokes (and actually…
Created on 10/7/2017 (updated 1 week ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 3142313  | 
Active
12
0
Sign in
to vote
From Connection: SQL Server
Queries with an order preserving repartition streams operator that access tables with the right data distribution can appear to hang. Instead of running for seconds as expected they can run for hours…
Created on 9/15/2017 (updated 2 weeks ago) | 5 validations | 0 workarounds | 1 comment | feedback id: 3141119  | 
Resolved
as Fixed Help for as Fixed
11
0
Sign in
to vote
From Connection: SQL Server
/2012/12/10/merge-bug-with-filtered-indexes.aspx). Only this bug demonstrates MERGE incorrectly reporting unique key violations with nonfiltered unique indexes, which is a much more common scenario (h…
Created on 7/14/2017 (updated 12 weeks ago) | 1 validation | 0 workarounds | 0 comments | feedback id: 3137805  | 
Active
0
0
Sign in
to vote
From Connection: SQL Server
I created a query recently which because of the database structure required 2 CTEs to create a sample list of dates and employee numbers and combine these together in a 3rd CTE so each date and employ…
Created on 7/12/2017 (updated 13 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3137649  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Using SQL Server 2008, 2012 and higher. CDC functions cdc.fn_cdc_get_net_changes_<capture_instance>() and cdc.fn_cdc_get_all_changes_<capture_instance>() are slow and produce incorrect results due t…
Created on 6/16/2017 (updated 11 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 3136110  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Source data (json file) are in UTF8 Codepage saved and german mutations are correctly displayed in different Texteditor (Notepad, Notepad++). Following SQL Statement is used to Import data from the …
Created on 6/14/2017 (updated 17 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 3136022  | 
Active
4
0
Sign in
to vote
Poor query plan with MAX + NOT EXISTS - by Erland Sommarskog
From Connection: SQL Server
I run a query like SELECT MAX(O.OrderID) FROM Orders O WHERE O.OrderID NOT IN (SELECT t.id FROM #temp t) Orders is a big table and #temp is small. The expected plan is that SQL Server would…
Created on 4/12/2017 (updated 16 weeks ago) | 0 validations | 0 workarounds | 9 comments | feedback id: 3132366  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
Error "The result set could not be merged because the result schema did not match the schema from the first responding server." from multiserver query in SQL 2012 for objects in DBO schema when datab…
Created on 3/31/2017 (updated 28 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 3131422  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
When you set a variable in the NOT MATCHED BY SOURCE, the engine ignores the declaration
Created on 2/15/2017 (updated 31 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 3123200  | 
Active
1
0
Sign in
to vote
From Connection: SQL Server
We have tested this conflict resolver with SQL 2016, SQL 2014, and SQL 2012 and observed the problem in all these versions of SQL server. The functionality works fine in earlier versions of Windows, b…
Created on 1/27/2017 (updated 9 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 3119850  | 
Closed
as Fixed Help for as Fixed
Showing 1 - 10 of 363 Previous 123 Next