Denormalization is a technique to move from higher to lower normal forms

What is de-normalization and when do you do it?

Question Posted / praveen

Answer Posted / praveen

Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to get a list all databases on the sql server?

575

Explain what are partitioned views and distributed partitioned views?

575

How to remove duplicate rows from table?

591

Is sql different from sql server?

507

What are the advantages of log shipping?

559

What are the reporting services components?

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1607

What is attribute relationships, why we need it? : sql server analysis services, ssas

498

What is the difference between Normalization and De-normalization?

556

How can you check the version of sql server?

555

What is inner join in sql server joins?

537

Do you know what is sql injection?

539

What is temporary stored procedure?

546

how can you attach more than 20 ldf files in sql server

1565

Explain how would you store your query in an SSRS report or a Database server?