Click here to Skip to main content
15,214,120 members
   

Database

 
Questiontwo phase commit in sql Pin
Soiraian22-Mar-13 23:22
MemberSoiraian22-Mar-13 23:22 
AnswerRe: two phase commit in sql Pin
Mycroft Holmes23-Mar-13 13:36
professionalMycroft Holmes23-Mar-13 13:36 
QuestionOLAP cube question (a) Edit Dimension and (b) Delete Partitiion Pin
devvvy21-Mar-13 16:07
Memberdevvvy21-Mar-13 16:07 
QuestionWant a query for for finding total number of non defected items. Pin
VishwaKL19-Mar-13 23:07
MemberVishwaKL19-Mar-13 23:07 
AnswerRe: Want a query for for finding total number of non defected items. Pin
Corporal Agarn20-Mar-13 1:03
professionalCorporal Agarn20-Mar-13 1:03 
GeneralRe: Want a query for for finding total number of non defected items. Pin
VishwaKL20-Mar-13 18:05
MemberVishwaKL20-Mar-13 18:05 
GeneralRe: Want a query for for finding total number of non defected items. Pin
Mycroft Holmes20-Mar-13 18:58
professionalMycroft Holmes20-Mar-13 18:58 
QuestionMS Sql normalization Pin
Per Söderlund19-Mar-13 21:40
MemberPer Söderlund19-Mar-13 21:40 
We have a production table with a column called sheets.
When we are making the final product in our production, sheets will be stored in another table called control_measures.

This means we will only store sheets in production when we are making the final product.

I want to know what you guys think.
Should I normalize and move sheets to a new table related to production or should i make it nullable as it is?

I know the recommended way of doing it in relational databases is normalization.
But still, I´m curious to know what you guys have to say about this.
AnswerRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 0:14
professionalJörgen Andersson20-Mar-13 0:14 
GeneralRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 0:20
MemberPer Söderlund20-Mar-13 0:20 
AnswerRe: MS Sql normalization Pin
Eddy Vluggen20-Mar-13 1:38
professionalEddy Vluggen20-Mar-13 1:38 
AnswerRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 2:34
professionalJörgen Andersson20-Mar-13 2:34 
GeneralRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 3:01
MemberPer Söderlund20-Mar-13 3:01 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 4:07
professionalJörgen Andersson20-Mar-13 4:07 
GeneralRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 4:38
MemberPer Söderlund20-Mar-13 4:38 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 4:45
professionalJörgen Andersson20-Mar-13 4:45 
GeneralRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 11:51
MemberPer Söderlund20-Mar-13 11:51 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 21:24
professionalJörgen Andersson20-Mar-13 21:24 
GeneralRe: MS Sql normalization Pin
Per Söderlund22-Mar-13 10:48
MemberPer Söderlund22-Mar-13 10:48 
GeneralRe: MS Sql normalization Pin
Eddy Vluggen20-Mar-13 8:14
professionalEddy Vluggen20-Mar-13 8:14 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 9:49
professionalJörgen Andersson20-Mar-13 9:49 
GeneralRe: MS Sql normalization Pin
Eddy Vluggen20-Mar-13 12:19
professionalEddy Vluggen20-Mar-13 12:19 
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 

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.