Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Normalization Rss

Search for any content tagged normalization

   Items 1 to 11 of 11   
 

Database Normalization Basics

The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.  Read more...
By Additional Articles 2014/04/23 | Source: SimpleTalk | Category: normalization
Rating:  Rate this |   Briefcase | 6,056 reads

Normalizing-Denormalized Tables

Explains how to normalize a table without breaking the application or doing any application code changes.  Read more...
By Mohit K. Gupta 2013/11/01 (first published: 2008/11/10) | Source: SQLServerCentral.com | Category: normalization
Rating: |  Discuss |   Briefcase | 22,002 reads

The Road to Professional Database Development: Database Normalization

Not only is the process of normalization valuable for increasing data quality and simplifying the process of modifying data, but it actually makes the database perform much faster. To prove the point, Peter Larsson takes a large unnormalised database and subjects it to successive stages of normalisation.  Read more...
By Additional Articles 2012/06/25 | Source: SimpleTalk | Category: normalization
Rating: (not yet rated)  Rate this |   Briefcase | 4,359 reads

Third Normal Form

The third article in our series on normalization from Tom Thomson continues with an explanation on what constitutes third normal form.  Read more...
By Tom Thomson 2011/07/28 | Source: SQLServerCentral.com | Category: normalization
Rating: |  Discuss |   Briefcase | 7,289 reads

Understanding First Normal Form in SQL Server

When we apply normalization rules to our database models, we're looking to preserve data integrity. Normalization reduces the duplication of data in a data model and seeks to ensure that data in a table is properly related to other data in that table.  Read more...
By 2011/07/15 | Source: MSSQLTips.com | Category: normalization
Rating: (not yet rated)  Rate this |   Briefcase | 3,505 reads

Second Normal Form

In this article Tom Thomson takes a look at what second normal form means, how it is violated, and how you can fix it. This is part of our normalization series.  Read more...
By Tom Thomson 2011/07/14 | Source: SQLServerCentral.com | Category: normalization
Rating: |  Discuss |   Briefcase | 7,638 reads

First Normal Form

Learn the basics of first normal form and what that means to a database designer from Tom Thomson.  Read more...
By Tom Thomson 2011/06/30 | Source: SQLServerCentral.com | Category: normalization
Rating: |  Discuss |   Briefcase | 10,335 reads

Fast normalization of a denormalized data source, using surrogate IDs

A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.  Read more...
By Adam Aspin 2010/01/25 | Source: SQLServerCentral.com | Category: normalization
Rating: |  Discuss |   Briefcase | 5,071 reads

Facts and Fallacies about First Normal Form

When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.  Read more...
By Additional Articles 2009/06/09 | Source: SimpleTalk | Category: database design
Rating:  Rate this |   Briefcase | 5,149 reads

Finding Values With Numerous Columns

Techniques for finding values in a denormalized table.  Read more...
By Timothy A Wiseman 2008/12/02 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 8,060 reads

Normalizing-Denormalized Tables

Explains how to normalize a table without breaking the application or doing any application code changes.  Read more...
By Mohit K. Gupta 2013/11/01 (first published: 2008/11/10) | Source: SQLServerCentral.com | Category: normalization
Rating: |  Discuss |   Briefcase | 22,002 reads
   Items 1 to 11 of 11