If someone were to ask me what normalization is during a job interview, that would be one of the mental check-boxes that I'd check of for reasons why I might want to work at that company. 😀 Like most folks, I couldn't give you a precise example of every form of normalization but I would point them to a great example of how not to do it.
After they get done explaining that many books could be named the same and that the ISBN is king, ask yourself where in the world is the ISBN after that explanation.
is pronounced "ree-bar
" and is a "Modenism
" for R
ow.First step towards the paradigm shift of writing Set Based code:________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Dear Lord... I'm a production DBA. Please grant me patience because, if you grant me strength, I'm gonna need bail money to go with it.
Helpful Links:How to post code problemsHow to Post Performance ProblemsCreate a Tally Function (fnTally)