top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is denormalization in context of SQLSERVER?

+1 vote
406 views
What is denormalization in context of SQLSERVER?
posted Mar 25, 2014 by Vishvachi Tiwari

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
Check this article, describes the denormalization in detail.
http://tech.queryhome.com/33685/denormalization-in-sql-server

1 Answer

+1 vote

Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance or if we are doing data warehousing and data mining. The sacrifice to performance is that you increase redundancy in database.

answer Mar 25, 2014 by Atul Mishra
Similar Questions
+1 vote

I have created two list boxes.
listbox1 has single selection and listbox 2 has multi-selection and 3 text-boxes. I want to insert the selected items from both list-boxes as well as data entered from text-boxes at same time. I mean same statement insert using c#.

+4 votes

I have a requirement in which a column in the table should have distinct values but it may have multiple null values. How can I achieve that?

...