Denormalization - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Denormalization

Author

Topic

swarnanp
Starting Member

2 Posts

Posted - 2005-03-08 : 00:47:00

Can some body plz explain me a scenario in which we would go for denormalization,it's advantages etc.
thanks a lot!

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-03-08 : 01:57:00

I can't think of one

Damian

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2005-03-08 : 02:52:56

<JEDI>
Move along... Nothing to see here....
</JEDI>

DavidM

A front-end is something that tries to violate a back-end.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-08 : 05:35:01

i'd have to say that denortmalization can be usefull when needed. those scenarios are rare but they can happen.
i once worked on an app that proved haveing denormalized table was acctually easier and quicker than having it properly normalized. it was of those apps for the government where the app wouldn't change if the law wouldn't change. and if the law changed then the app would become obsolete so it didn't matter

Go with the flow & have fun! Else fight the flow

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-03-08 : 06:05:06

SHHHHHHHHHHH

Damian

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-08 : 08:02:46

oh ok.... my bad... sorry ...

Go with the flow & have fun! Else fight the flow

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-03-08 : 10:17:46

I believe if you search the forum for "denormalization", you will find millions of threads about this very thing. Try that, and let us know if you need more information.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Xerxes
Aged Yak Warrior

666 Posts

Posted - 2005-03-08 : 10:21:07

I'm gonna comment on this one.....take my advice swarnanp! Don't go there! Curiosity about DE-normalization is like being curious about the swamp and then when you're hip deep into it you see the crocodile!

Semper fi,

XERXES, USMC(Ret.)
------------------------------------------------------
The Marine Corps taught me everything but SQL!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources