nslupi | SQLServerCentral

nslupi

Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

RE: Merge from Heap to Clustered Index Table.... Improvements?

Jonathan AC Roberts - Thursday, February 21, 2019 6:40 AM
It might be my lack of understanding about the MERGE statement, I've always...

February 21, 2019 at 9:43 am

#2022566
RE: Merge from Heap to Clustered Index Table.... Improvements?

Eric M Russell - Wednesday, February 20, 2019 3:00 PM
nslupi - Wednesday, February 20, 2019 12:43 PM

February 20, 2019 at 3:24 pm

#2022523
RE: Merge from Heap to Clustered Index Table.... Improvements?

ScottPletcher - Wednesday, February 20, 2019 12:42 PM
You should cluster the staging table on the DM_KEY_HASH also, assuming you can compute the hash...

February 20, 2019 at 12:52 pm

#2022507
RE: Merge from Heap to Clustered Index Table.... Improvements?

Eric M Russell - Wednesday, February 20, 2019 12:39 PM
Rather than hash key matching, consider implementing Change Tracking on the source table,...

February 20, 2019 at 12:43 pm

#2022506
RE: Merge from Heap to Clustered Index Table.... Improvements?

frederico_fonseca - Wednesday, February 20, 2019 12:13 PM
Plan not attached. -- saw it now.
The main performance improvement on this type of process...

February 20, 2019 at 12:35 pm

#2022503

Viewing 5 posts - 1 through 6 (of 6 total)