Click here to Skip to main content
15,561,948 members
Home / Discussions / Database
   

Database

 
AnswerRe: possible to get results of 3 different tables in 1 set of column results? Pin
Eddy Vluggen6-Jun-15 6:14
professionalEddy Vluggen6-Jun-15 6:14 
SuggestionRe: possible to get results of 3 different tables in 1 set of column results? Pin
Sascha Lefèvre7-Jun-15 11:09
professionalSascha Lefèvre7-Jun-15 11:09 
QuestionSql Server Pin
Member 117451955-Jun-15 10:09
Member 117451955-Jun-15 10:09 
AnswerRe: Sql Server Pin
Eddy Vluggen5-Jun-15 10:25
professionalEddy Vluggen5-Jun-15 10:25 
AnswerRe: Sql Server Pin
Richard Deeming5-Jun-15 11:24
mveRichard Deeming5-Jun-15 11:24 
QuestionProvide large data updates to desktop users Pin
Kukreja Sonu3-Jun-15 2:53
Kukreja Sonu3-Jun-15 2:53 
AnswerRe: Provide large data updates to desktop users Pin
Mycroft Holmes3-Jun-15 15:42
professionalMycroft Holmes3-Jun-15 15:42 
AnswerRe: Provide large data updates to desktop users Pin
Mycroft Holmes3-Jun-15 20:51
professionalMycroft Holmes3-Jun-15 20:51 
You will get better ideas if you reply through the forum! There are others who will be able to help better than I.
Kukreja Sonu wrote:
Thanks Holmes. As of now we write all the changed data into an XML file at server and upload the same to a centralized location. Then client downloads the xml and executes queries one by one accordingly to update target DB.
But this is a long process:
1. Populating DB at server with change only data
2. Initiate process to prepare XML based on above data.
3. Client downloads the XML and update target DB.
This takes around 3-4 days for single run. So, we want to have some other process if possible to minimize the time


The more I think about this the nastier it gets, are you up to changing the way you identify your change sets or do you have to stick with the current design/structure?

First I would look into change the format from xml to something less verbose. XML is fine for communication as a transport medium it sucks. We use CSV.

It sounds like each client has a different requirement!
Never underestimate the power of human stupidity
RAH

QuestionI'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 11:12
professionaljkirkerx2-Jun-15 11:12 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 11:13
professionaljkirkerx2-Jun-15 11:13 
AnswerRe: I'm trying to concat 2 columns into a single result Pin
Sascha Lefèvre2-Jun-15 11:43
professionalSascha Lefèvre2-Jun-15 11:43 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 11:55
professionaljkirkerx2-Jun-15 11:55 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
Sascha Lefèvre2-Jun-15 12:02
professionalSascha Lefèvre2-Jun-15 12:02 
QuestionRemoving the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf2-Jun-15 9:32
Stephen Holdorf2-Jun-15 9:32 
AnswerRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming2-Jun-15 23:20
mveRichard Deeming2-Jun-15 23:20 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 2:55
Stephen Holdorf3-Jun-15 2:55 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 4:06
mveRichard Deeming3-Jun-15 4:06 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 4:13
Stephen Holdorf3-Jun-15 4:13 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 4:25
mveRichard Deeming3-Jun-15 4:25 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 4:32
Stephen Holdorf3-Jun-15 4:32 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 4:34
mveRichard Deeming3-Jun-15 4:34 
QuestionLDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 0:30
Azam Niaz Ch.1-Jun-15 0:30 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 0:57
professionalKornfeld Eliyahu Peter1-Jun-15 0:57 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 1:07
Azam Niaz Ch.1-Jun-15 1:07 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 1:15
professionalKornfeld Eliyahu Peter1-Jun-15 1:15 

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.