Click here to Skip to main content
15,867,785 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 5:14
professionalEddy Vluggen6-Jun-15 5:14 
SuggestionRe: possible to get results of 3 different tables in 1 set of column results? Pin
Sascha Lefèvre7-Jun-15 10:09
professionalSascha Lefèvre7-Jun-15 10:09 
QuestionSql Server Pin
Member 117451955-Jun-15 9:09
Member 117451955-Jun-15 9:09 
AnswerRe: Sql Server Pin
Eddy Vluggen5-Jun-15 9:25
professionalEddy Vluggen5-Jun-15 9:25 
AnswerRe: Sql Server Pin
Richard Deeming5-Jun-15 10:24
mveRichard Deeming5-Jun-15 10:24 
QuestionProvide large data updates to desktop users Pin
Kukreja Sonu3-Jun-15 1:53
Kukreja Sonu3-Jun-15 1:53 
AnswerRe: Provide large data updates to desktop users Pin
Mycroft Holmes3-Jun-15 14:42
professionalMycroft Holmes3-Jun-15 14:42 
AnswerRe: Provide large data updates to desktop users Pin
Mycroft Holmes3-Jun-15 19:51
professionalMycroft Holmes3-Jun-15 19: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 10:12
professionaljkirkerx2-Jun-15 10:12 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 10:13
professionaljkirkerx2-Jun-15 10:13 
AnswerRe: I'm trying to concat 2 columns into a single result Pin
Sascha Lefèvre2-Jun-15 10:43
professionalSascha Lefèvre2-Jun-15 10:43 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 10:55
professionaljkirkerx2-Jun-15 10:55 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
Sascha Lefèvre2-Jun-15 11:02
professionalSascha Lefèvre2-Jun-15 11:02 
QuestionRemoving the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf2-Jun-15 8:32
Stephen Holdorf2-Jun-15 8:32 
AnswerRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming2-Jun-15 22:20
mveRichard Deeming2-Jun-15 22:20 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 1:55
Stephen Holdorf3-Jun-15 1:55 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 3:06
mveRichard Deeming3-Jun-15 3:06 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 3:13
Stephen Holdorf3-Jun-15 3:13 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 3:25
mveRichard Deeming3-Jun-15 3:25 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 3:32
Stephen Holdorf3-Jun-15 3:32 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 3:34
mveRichard Deeming3-Jun-15 3:34 
QuestionLDF file Size is so increased Pin
Azam Niaz Ch.31-May-15 23:30
Azam Niaz Ch.31-May-15 23:30 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter31-May-15 23:57
professionalKornfeld Eliyahu Peter31-May-15 23:57 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 0:07
Azam Niaz Ch.1-Jun-15 0:07 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 0:15
professionalKornfeld Eliyahu Peter1-Jun-15 0: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.