what is normalization?
what is denormalization?
Answer Posted / sarika desai
Normalization is a concept of Eliminating data redundancy,
Improve database performance & Index Improvement.
De-normalization is the process of attempting to optimize
the performance of a database by adding redundant data.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to download and install sql server 2005 books online?
What is the correct order of the logical query processing phases?
Why should we go for stored procedures? Why not direct queries?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is blocking?
How does recursive cte works in sql server?
How to rebuild indexes with alter index ... Rebuild?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What are the diifferences between the ms sql server vs mysql?
Write an sql query for deleting duplicate rows?
What are pessimistic lock and optimistic lock?
List some case manipulation functions in sql?
When would you use it?
Does table partitioning improve performance?
What is the stored procedure?