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

Articles with tag denormalization Rss

Search for any content tagged denormalization

   Items 1 to 7 of 7   
 

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 | 21,848 reads

Condensing a Delimited List of Integers in SQL Server

In real-world applications, it often makes sense to show denormalized data, such as delimited lists, within the application's user interface. Dwain Camps shows why, and how, the distribution business stores information about 'islands' in sequences in order to track the status of the shipping of a consignment. It makes a great SQL puzzle.  Read more...
By Additional Articles 2013/09/12 | Source: SimpleTalk | Category: delimited list
Rating:  Rate this |   Briefcase | 2,918 reads

A faster way to prepare dimensional databases

When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?  Read more...
By Adam Aspin 2010/12/17 (first published: 2010/02/24) | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 15,587 reads

Denormalization in SQL Server for Fun and Profit

Normalization is standard practice in database design, however, an over-normalized database can have issues. This article examines the case for denormalization.  Read more...
By Additional Articles 2010/12/09 | Source: SQL Server Performance | Category: denormalization
Rating:  Rate this |   Briefcase | 4,261 reads

Denormalization Strategies

In building a database, typically we want a well normalized design. However there are cases for considering options for denormalization in complex systems. Timothy Claason gives you some thoughts on the subject.  Read more...
By Timothy Claason 2010/03/15 | Source: SQLServerCentral.com | Category: denormalization
Rating: |  Discuss |   Briefcase | 10,345 reads

A faster way to prepare dimensional databases

When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?  Read more...
By Adam Aspin 2010/12/17 (first published: 2010/02/24) | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 15,587 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 | 21,848 reads
   Items 1 to 7 of 7