New answers tagged

1

Answer originally left as a comment by A-K: To propagate IsArchived flag, you can use ON UPDATE CASCADE. Because you search on serial number, you want to keep both current and archived rows in one table, with UNIQUE or PRIMARY KEY enforcing its uniqueness.


1

Finding if an in-coming string already exists in the dimension table will be slow. What you're trying to do is map an arbitrarily long string to an integer surrogate key. This sounds like a hash to me. As the values are written to the staging table calculate a hash of the string and store it also. This hash will be used as the surrogate key in the dimension. ...


2

The whole process you described is implemented in the database engine itself for the columnstore compression. DB engine will scan data for repeating text, find duplicates and create dictionary tables. In the row data it will keep only minimal references to dictionary. Be sure to keep data batches big enough to trigger this compression process during insert - ...


4

Here's a Microsoft article that does a pretty good job explaining normalization and the different forms, albeit a little dated regarding Microsoft Access, the theory and principals still apply. In short, database normalization employs the following benefits: Reduces data redundancy which improves maintainability. As you see in your example table ...


0

I'm not the one who downvoted your question, so I can't speak on behalf of that person, but my guess is because your question is a little abstract and wordy, and this site is usually for more direct and concretely worded questions, that was the downvoter's reasoning, because it's a little unclear exactly what your goals are / what you're asking. That being ...


1

A set of attributes Y is functionally dependent from another set X if and only if Y is uniquely determined by X, that is you cannot have two different values of Y associated to the same value of X. So, for instance, assuming that a phone number is tied always to only one person, and that a person has always only one address, you can say that the functional ...


Top 50 recent answers are included