SQL Server Functions Question:

What is De-normalization?

MS SQL Server Functions Interview Question
MS SQL Server Functions Interview Question

Answer:

The process of adding redundant data to get rid of complex join, in order to optimize database performance. This is done to speed up database access by moving from higher to lower form of normalization.


Previous QuestionNext Question
Explain Steps of normalization?What do you know about Normalization and De- Normalization?