1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Tell me about the approaches which you used to counter the DI problems.

Question Posted / sandeep kumar


Tell me about the approaches which you used to counter the DI problems...

Answer / Pradeep Kumar Srivastav

One approach to counter Data Interdependence (DI) problems in SQL Server is Normalization, which organizes data into tables to reduce redundancy and improve data integrity. Another approach is Denormalization, which intentionally duplicates data to improve query performance at the cost of increased data redundancy.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

How to locate and take substrings with charindex() and substring() functions?

1 Answers  

What are the disadvantages of indexes?

1 Answers  

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

What is a virtual table in sql?

1 Answers  

What is coalesce in sql server?

1 Answers  

What is the difference between insensitive and scroll cursor?

1 Answers  

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

How to specify the collation for a character data type in ms sql server?

1 Answers  

Why Do you want to work in this company?

4 Answers   HCL,

How to assign null values to variables or columns?

1 Answers  

What is the use of tempdb? What values does it hold?

1 Answers   Abacus,

For more SQL Server Interview Questions Click Here
Categories