Click here to Skip to main content
12,755,975 members (36,194 online)
   

Database

 
AnswerRe: MS SQL - Tinyint - Default Value Pin
Mycroft Holmes16-Nov-12 16:11
memberMycroft Holmes16-Nov-12 16:11 
GeneralRe: MS SQL - Tinyint - Default Value Pin
jschell17-Nov-12 7:29
memberjschell17-Nov-12 7:29 
GeneralRe: MS SQL - Tinyint - Default Value Pin
Mycroft Holmes17-Nov-12 16:06
memberMycroft Holmes17-Nov-12 16:06 
AnswerRe: MS SQL - Tinyint - Default Value Pin
JammoD8716-Nov-12 23:30
memberJammoD8716-Nov-12 23:30 
QuestionStaging Area Pin
Phanindra26115-Nov-12 10:05
memberPhanindra26115-Nov-12 10:05 
AnswerRe: Staging Area Pin
mark merrens15-Nov-12 10:37
membermark merrens15-Nov-12 10:37 
GeneralRe: Staging Area Pin
Phanindra26116-Nov-12 1:14
memberPhanindra26116-Nov-12 1:14 
GeneralRe: Staging Area Pin
mark merrens16-Nov-12 8:58
membermark merrens16-Nov-12 8:58 
No, I said the data was temporarily stored: the tables are a permanent fixture and are used to transition that data before it gets exposed in the production tables. For my purposes it's okay for the tables to reside in the prod database but that might not suit you. There is no reason it can't be a wholly separate database: that's up to you and the requirements.

All of the code is either in stored procedures and/or c#. The usual scenario is that the tables are truncated and (in my case) filtered data is dumped into them and then other processes may work on them and then the data is moved to the primary tables.

Note that this is just how our solution works for us: it may not be right for you. Use anything like this with extreme caution, especially near production data.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

QuestionRe: Staging Area Pin
Phanindra26116-Nov-12 9:11
memberPhanindra26116-Nov-12 9:11 
AnswerRe: Staging Area Pin
mark merrens16-Nov-12 9:34
membermark merrens16-Nov-12 9:34 
AnswerRe: Staging Area Pin
Mycroft Holmes16-Nov-12 16:20
memberMycroft Holmes16-Nov-12 16:20 
GeneralRe: Staging Area Pin
S Douglas27-Nov-12 20:38
memberS Douglas27-Nov-12 20:38 
GeneralRe: Staging Area Pin
Mycroft Holmes27-Nov-12 21:31
memberMycroft Holmes27-Nov-12 21:31 
GeneralRe: Staging Area Pin
S Douglas29-Nov-12 8:52
memberS Douglas29-Nov-12 8:52 
Questionfirst linq for entity frame work? Pin
Member 875182715-Nov-12 2:02
memberMember 875182715-Nov-12 2:02 
AnswerRe: first linq for entity frame work? Pin
digimanus15-Nov-12 4:17
memberdigimanus15-Nov-12 4:17 
QuestionBEGIN TRANSACTION AND COMMIT TRANSACTION Pin
vanikanc14-Nov-12 8:40
membervanikanc14-Nov-12 8:40 
AnswerRe: BEGIN TRANSACTION AND COMMIT TRANSACTION Pin
Phanindra26114-Nov-12 9:40
memberPhanindra26114-Nov-12 9:40 
QuestionFault Exception in WCF Services Pin
Phanindra26114-Nov-12 7:15
memberPhanindra26114-Nov-12 7:15 
AnswerRe: Fault Exception in WCF Services Pin
Eddy Vluggen14-Nov-12 7:36
memberEddy Vluggen14-Nov-12 7:36 
GeneralRe: Fault Exception in WCF Services Pin
Phanindra26114-Nov-12 9:05
memberPhanindra26114-Nov-12 9:05 
QuestionRelation multiple table using in C# Pin
YBG13-Nov-12 3:53
memberYBG13-Nov-12 3:53 
AnswerRe: Relation multiple table using in C# Pin
Phanindra26114-Nov-12 9:23
memberPhanindra26114-Nov-12 9:23 
QuestionTrying to get a MySQL subquery to return multiple records Pin
SQL Ed12-Nov-12 9:19
memberSQL Ed12-Nov-12 9:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 12:33
memberEddy Vluggen12-Nov-12 12:33 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.170217.1 | Last Updated 21 Feb 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid