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

Content with tag denormalization Rss

   Items 1 to 9 of 9   
 

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,982 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,966 reads

1NF View Generator

Creates a view/select statement for given transactional table using foreign key info. Great for ETL extraction or History table routine.  Read more...
By Mark Stockwell 2011/06/27 | Source: SQLServerCentral.com | Category: first normal form
Rating: |  Discuss |   Briefcase | 1,657 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,627 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,289 reads

1NF View Generator

Creates a view/select statement for given transactional table using foreign key info. Great for ETL extraction or History table routine.  Read more...
By Mark Stockwell 2011/06/27 | Source: SQLServerCentral.com | Category: first normal form
Rating: |  Discuss |   Briefcase | 1,657 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,360 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,627 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,982 reads
   Items 1 to 9 of 9   
 
Tags
database design (3)    
analysis services (ssas) (1)    
delimited list (1)    
dimensional modelling (1)    
etl extraction (1)    
first normal form (1)    
foreign keys (fk) (1)    
history table (1)    
normalization (1)    
transactions (1)