<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
denormalization
Items 1 to 7 of 7
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,604 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,454 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,216 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,604 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,309 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,454 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
2008/11/10
|
Source:
SQLServerCentral.com
|
Category:
normalization
Rating:
|
Discuss
|
Briefcase
|
13,380 reads
Items 1 to 7 of 7
Tags
database design
(3)
analysis services (ssas)
(1)
dimensional modelling
(1)
etl extraction
(1)
first normal form
(1)
foreign keys (fk)
(1)
history table
(1)
normalization
(1)
transactions
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
