Click here to Skip to main content
15,946,988 members
Home / Discussions / Database
   

Database

 
GeneralRe: Where to do the processing Pin
Kornfeld Eliyahu Peter16-Feb-14 1:27
professionalKornfeld Eliyahu Peter16-Feb-14 1:27 
GeneralRe: Where to do the processing Pin
Tim Carmichael16-Feb-14 7:43
Tim Carmichael16-Feb-14 7:43 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 11:44
professionalMycroft Holmes16-Feb-14 11:44 
AnswerRe: Where to do the processing Pin
GuyThiebaut17-Feb-14 0:17
professionalGuyThiebaut17-Feb-14 0:17 
GeneralRe: Where to do the processing Pin
Mycroft Holmes17-Feb-14 0:34
professionalMycroft Holmes17-Feb-14 0:34 
GeneralRe: Where to do the processing Pin
GuyThiebaut17-Feb-14 0:39
professionalGuyThiebaut17-Feb-14 0:39 
AnswerRe: Where to do the processing Pin
Jörgen Andersson17-Feb-14 0:59
professionalJörgen Andersson17-Feb-14 0:59 
AnswerRe: Where to do the processing Pin
jschell17-Feb-14 12:16
jschell17-Feb-14 12:16 
Per the other post... "process each record 36 to 120 times"

Given that it seems likely that the processing isn't going to be simple. So that suggests the TSQL is going to be rather CPU intensive.

So what is the expectation of other work that the database needs to do at the same time that this runs, now and in the future?

And what is the growth rate of the record set?

Does this occur every day?

Moving records out of and into the system is of concern but given the processing numbers above it is something I would consider. A separate application allows processing to be moved off box (easier at least with my experience.)
AnswerRe: Where to do the processing Pin
Nicholas Swandel21-Feb-14 8:46
Nicholas Swandel21-Feb-14 8:46 
Questionconvert mints into hours Pin
Member 1056208613-Feb-14 2:59
Member 1056208613-Feb-14 2:59 
AnswerRe: convert mints into hours Pin
Richard MacCutchan13-Feb-14 4:29
mveRichard MacCutchan13-Feb-14 4:29 
QuestionIt Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Dnyaneshwar@Pune13-Feb-14 1:52
Dnyaneshwar@Pune13-Feb-14 1:52 
AnswerRe: It Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Dnyaneshwar@Pune13-Feb-14 2:15
Dnyaneshwar@Pune13-Feb-14 2:15 
AnswerRe: It Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Richard Deeming13-Feb-14 2:51
mveRichard Deeming13-Feb-14 2:51 
GeneralRe: It Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Dnyaneshwar@Pune14-Feb-14 1:05
Dnyaneshwar@Pune14-Feb-14 1:05 
QuestionSQL query for availability Error Pin
Sniper 312-Feb-14 19:10
professionalSniper 312-Feb-14 19:10 
AnswerRe: SQL query for availability Error Pin
Chris Quinn12-Feb-14 20:52
Chris Quinn12-Feb-14 20:52 
GeneralRe: SQL query for availability Error Pin
Sniper 312-Feb-14 21:05
professionalSniper 312-Feb-14 21:05 
GeneralRe: SQL query for availability Error Pin
Chris Quinn12-Feb-14 21:08
Chris Quinn12-Feb-14 21:08 
GeneralRe: SQL query for availability Error Pin
Mycroft Holmes12-Feb-14 22:02
professionalMycroft Holmes12-Feb-14 22:02 
Questioncalculate percentage of two column value and store into other column Pin
Member 1056208612-Feb-14 19:00
Member 1056208612-Feb-14 19:00 
AnswerRe: calculate percentage of two column value and store into other column Pin
Simon_Whale12-Feb-14 22:29
Simon_Whale12-Feb-14 22:29 
GeneralRe: calculate percentage of two column value and store into other column Pin
Member 1056208612-Feb-14 22:41
Member 1056208612-Feb-14 22:41 
GeneralRe: calculate percentage of two column value and store into other column Pin
Simon_Whale12-Feb-14 22:45
Simon_Whale12-Feb-14 22:45 
AnswerRe: calculate percentage of two column value and store into other column Pin
Nicholas Swandel21-Feb-14 4:05
Nicholas Swandel21-Feb-14 4:05 

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.