Click here to Skip to main content
14,579,769 members
   

Database

 
QuestionRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 9:57
professionalJörgen Andersson20-Mar-13 9:57 
AnswerRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 11:44
MemberPer Söderlund20-Mar-13 11:44 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 21:33
professionalJörgen Andersson20-Mar-13 21:33 
GeneralRe: MS Sql normalization Pin
Per Söderlund22-Mar-13 10:59
MemberPer Söderlund22-Mar-13 10:59 
Questionlinked server Pin
rocksonedmond19-Mar-13 5:45
Memberrocksonedmond19-Mar-13 5:45 
SuggestionRe: linked server Pin
Maciej Los19-Mar-13 7:39
mveMaciej Los19-Mar-13 7:39 
AnswerRe: linked server Pin
RedDk22-Mar-13 8:23
MemberRedDk22-Mar-13 8:23 
QuestionThreading and insert/update issues. Pin
mjackson1118-Mar-13 18:06
Membermjackson1118-Mar-13 18:06 
I have a database that receives weather information. The main table is (somewhat simplified)

LocationID int, Hour int, HiTemp Float, LoTemp Float, TimedTemp Float

Temperature data is first written to a holding table - LocationID int, Hour int, whichVariable int, value float. Then it is merged into the main table (using a MERGE statement)

All this works fine when the temperature data written to the holding table goes in one variable at a time, executes the MERGE, loads the next variable, etc.

If I have multiple programs adding multiple locations and different variables all at the same time, the system deadlocks. I could force one instance of the outside program inserting the data to use a mutex to guarantee undisturbed calls to MERGE but it is quite possible we will have multiple instances of the outside program running.

What is the best approach to take to allow merging of the data?
AnswerRe: Threading and insert/update issues. Pin
Mycroft Holmes18-Mar-13 19:33
professionalMycroft Holmes18-Mar-13 19:33 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 3:53
Membermjackson1119-Mar-13 3:53 
AnswerRe: Threading and insert/update issues. Pin
PIEBALDconsult19-Mar-13 4:10
professionalPIEBALDconsult19-Mar-13 4:10 
AnswerRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 5:17
professionalGuyThiebaut19-Mar-13 5:17 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 5:58
Membermjackson1119-Mar-13 5:58 
GeneralRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 6:07
professionalGuyThiebaut19-Mar-13 6:07 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 14:18
Memberkalula17-Mar-13 14:18 
AnswerRe: how did i add calender to my site Pin
NotPolitcallyCorrect17-Mar-13 14:22
MemberNotPolitcallyCorrect17-Mar-13 14:22 
AnswerRe: how did i add calender to my site Pin
Mycroft Holmes17-Mar-13 19:57
professionalMycroft Holmes17-Mar-13 19:57 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 14:16
Memberkalula17-Mar-13 14:16 
AnswerRe: how did i add calender to my site Pin
thatraja4-Oct-13 20:39
professionalthatraja4-Oct-13 20:39 
QuestionSkeptical about Trigger! Pin
Thiru614-Mar-13 23:10
MemberThiru614-Mar-13 23:10 
QuestionRe: Skeptical about Trigger! Pin
gvprabu14-Mar-13 23:52
Membergvprabu14-Mar-13 23:52 
AnswerRe: Skeptical about Trigger! Pin
Thiru615-Mar-13 23:22
MemberThiru615-Mar-13 23:22 
SuggestionRe: Skeptical about Trigger! Pin
gvprabu17-Mar-13 18:37
Membergvprabu17-Mar-13 18:37 
GeneralRe: Skeptical about Trigger! Pin
Thiru617-Mar-13 19:16
MemberThiru617-Mar-13 19:16 
AnswerRe: Skeptical about Trigger! Pin
Mycroft Holmes14-Mar-13 23:58
professionalMycroft Holmes14-Mar-13 23:58 

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.