Click here to Skip to main content
14,365,177 members
   

Database

 
Questionlinked server Pin
rocksonedmond19-Mar-13 6:45
memberrocksonedmond19-Mar-13 6:45 
SuggestionRe: linked server Pin
Maciej Los19-Mar-13 8:39
protectorMaciej Los19-Mar-13 8:39 
AnswerRe: linked server Pin
RedDk22-Mar-13 9:23
memberRedDk22-Mar-13 9:23 
QuestionThreading and insert/update issues. Pin
mjackson1118-Mar-13 19:06
membermjackson1118-Mar-13 19:06 
AnswerRe: Threading and insert/update issues. Pin
Mycroft Holmes18-Mar-13 20:33
memberMycroft Holmes18-Mar-13 20:33 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 4:53
membermjackson1119-Mar-13 4:53 
AnswerRe: Threading and insert/update issues. Pin
PIEBALDconsult19-Mar-13 5:10
protectorPIEBALDconsult19-Mar-13 5:10 
AnswerRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 6:17
professionalGuyThiebaut19-Mar-13 6:17 
Here's an idea:
Set up a table that is a queue table.
Just insert all the data into this table - no merge needed.

Then you have one process that reads from this table performing merges and deleting the row from the queue once the merge has been performed.

As you are only performing inserts then deletes on the queue I can't see a deadlock occurring on the queue - as the process will be issuing one merge at a time you should avoids deadlocks on your merge table too.
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 6:58
membermjackson1119-Mar-13 6:58 
GeneralRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 7:07
professionalGuyThiebaut19-Mar-13 7:07 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 15:18
memberkalula17-Mar-13 15:18 
AnswerRe: how did i add calender to my site Pin
NotPolitcallyCorrect17-Mar-13 15:22
memberNotPolitcallyCorrect17-Mar-13 15:22 
AnswerRe: how did i add calender to my site Pin
Mycroft Holmes17-Mar-13 20:57
memberMycroft Holmes17-Mar-13 20:57 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 15:16
memberkalula17-Mar-13 15:16 
AnswerRe: how did i add calender to my site Pin
thatraja4-Oct-13 21:39
protectorthatraja4-Oct-13 21:39 
QuestionSkeptical about Trigger! Pin
Thiru615-Mar-13 0:10
memberThiru615-Mar-13 0:10 
QuestionRe: Skeptical about Trigger! Pin
gvprabu15-Mar-13 0:52
membergvprabu15-Mar-13 0:52 
AnswerRe: Skeptical about Trigger! Pin
Thiru616-Mar-13 0:22
memberThiru616-Mar-13 0:22 
SuggestionRe: Skeptical about Trigger! Pin
gvprabu17-Mar-13 19:37
membergvprabu17-Mar-13 19:37 
GeneralRe: Skeptical about Trigger! Pin
Thiru617-Mar-13 20:16
memberThiru617-Mar-13 20:16 
AnswerRe: Skeptical about Trigger! Pin
Mycroft Holmes15-Mar-13 0:58
memberMycroft Holmes15-Mar-13 0:58 
GeneralRe: Skeptical about Trigger! Pin
Jörgen Andersson15-Mar-13 3:16
protectorJörgen Andersson15-Mar-13 3:16 
GeneralRe: Skeptical about Trigger! Pin
Mycroft Holmes15-Mar-13 14:23
memberMycroft Holmes15-Mar-13 14:23 
GeneralRe: Skeptical about Trigger! Pin
Jörgen Andersson15-Mar-13 15:09
protectorJörgen Andersson15-Mar-13 15:09 
GeneralRe: Skeptical about Trigger! Pin
Thiru616-Mar-13 0:25
memberThiru616-Mar-13 0:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.