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

1
0
Sign in
to vote
From Connection: SQL Server
The query below, which uses a .net clr function to split a string into a table of numbers and perfoms joins on them, used to take around 50 ms with SQL Server 2012. Now, on SQL Server 2016 SP1 with CU…
Created on 11/3/2017 (updated 5 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 3143358  | 
Active
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 session. Such locking behavior provokes (and actually…
Created on 10/7/2017 (updated 4 weeks 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 | 2 comments | 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 20 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 22 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 19 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 26 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 24 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 36 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 39 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 3123200  | 
Active
Showing 1 - 10 of 364 Previous 123 Next