Click here to Skip to main content
14,579,890 members
   

Database

 
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 
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 
The proper answer you got from Eddy.

Mine is that it depends, I'd rather normalize once to many than once to few.

As I don't know anything about your domain, I also don't know if there are changes to your database to expect.
But it's also about performance, most of the time (not always) normalization boosts performance in contrary to popular belief. The most obvious exception is OLAP.
Here's an excellent article[^] on that subject.

Whether or not nulls is a performance hit or not also depends on what database you're using, Oracle for example isn't ISO compliant in this matter and doesn't store NULL values at all, the lack of a value is the NULL value.
SQL Server on the other hand stores a NULL token that takes two bytes for variable length data and the full space for fixed length data. So if you have a column with a high percentage of nulls you get a hit on memory compared to a separate table. If there's a low percentage of nulls you can keep it in the original table.
And then again, SQL Server nowadays have SPARSE Columns. Can't say for sure how well it works as I have never used them. But at least in theory they should have fixed the problem, but give you an extra join for the null bitmap.
"The ones who care enough to do it right care too much to compromise."
Matthew Faithfull

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 
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 

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.