Click here to Skip to main content
15,212,427 members
   

Database

 
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 
Jörgen Andersson wrote:
Normalize 'til it hurts, denormalize 'til it works
It already hurts to read that. Normalize to 3NF, or better yet, BCNF. Denormalization should only be done when one can explain the trade-offs made, and the advantage gained.

Jörgen Andersson wrote:
Your CRUD operations will become complicated.
Only if you take a religious stance on optional fields. The other "recommendations" wouldn't impact the typical data-operations, nor complicate your queries.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

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 
GeneralRe: MS Sql normalization Pin
Per Söderlund22-Mar-13 10:59
MemberPer Söderlund22-Mar-13 10:59 
Questionlinked server Pin
rocksonedmond19-Mar-13 5:45
Memberrocksonedmond19-Mar-13 5:45 
SuggestionRe: linked server Pin
Maciej Los19-Mar-13 7:39
mveMaciej Los19-Mar-13 7:39 
AnswerRe: linked server Pin
RedDk22-Mar-13 8:23
MemberRedDk22-Mar-13 8:23 
QuestionThreading and insert/update issues. Pin
mjackson1118-Mar-13 18:06
Membermjackson1118-Mar-13 18:06 
AnswerRe: Threading and insert/update issues. Pin
Mycroft Holmes18-Mar-13 19:33
professionalMycroft Holmes18-Mar-13 19:33 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 3:53
Membermjackson1119-Mar-13 3:53 
AnswerRe: Threading and insert/update issues. Pin
PIEBALDconsult19-Mar-13 4:10
professionalPIEBALDconsult19-Mar-13 4:10 
AnswerRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 5:17
professionalGuyThiebaut19-Mar-13 5:17 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 5:58
Membermjackson1119-Mar-13 5:58 
GeneralRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 6:07
professionalGuyThiebaut19-Mar-13 6:07 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 14:18
Memberkalula17-Mar-13 14:18 

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.