Discussion about normal forms in SQL

[charygaru]

[quote author=ronitreddy link=topic=219396.msg2702972#msg2702972 date=1312301165]
habba oddu baa cursors antene bhayam  cry@fl cry@fl cry@fl

[size=5]denormali zation gurinchi cheppochu kada[/size]
[/quote]

@gr33d @gr33d @gr33d @gr33d @gr33d @gr33d

[galigannarao]

[quote author=charygaru link=topic=219396.msg2702985#msg2702985 date=1312301444]
@gr33d @gr33d @gr33d @gr33d @gr33d @gr33d
[/quote]sare  &D_@@ &D_@@

[Ranga_The_Donga]

[quote author=meghana9 link=topic=219396.msg2702981#msg2702981 date=1312301344]
cursors ipudu use chetshunnara ? adhi ekuva use cheyaru... it slowers the performance of the database
[/quote] @gr33d @gr33d @gr33d

debugging of data ki kavali...

oka table lo transaction numbers millions vunnayi...

each transaction number ki related info..other table lo vuntadhi......

wen u want to move the data which was related......e cursor one time use chesthe......row by row choosukoni processing chesthadhi....

s.....it takes long time.....

[manoghna]

[quote author=Jeedeelu link=topic=219396.msg2702990#msg2702990 date=1312301496]
@gr33d @gr33d @gr33d

debugging of data ki kavali...

oka table lo transaction numbers millions vunnayi...

each transaction number ki related info..other table lo vuntadhi......

wen u want to move the data which was related......e cursor one time use chesthe......row by row choosukoni processing chesthadhi....

s.....it takes long time.....
[/quote] thankyou thankyou

[ronitreddy]

Meghana

Are you working as SQL Developer? sCo_^Y sCo_^Y

[ronitreddy]

Gali

baa..nu deni mida working ?

[galigannarao]

[quote author=ronitreddy link=topic=219396.msg2703055#msg2703055 date=1312302674]
Gali

baa..nu deni mida working ?
[/quote]nenu .net devloper baaa &D_@@ &D_@@ &D_@@ &D_@@

[manoghna]

Ok lets start Denormalization?

Asalu Denormalization epudu use chestham? lets discuss on this first and then ela use cheyali anedhi discuss chedham ... emi antaru  sSa_j@il

[pulithoka]

[quote author=meghana9 link=topic=219396.msg2703109#msg2703109 date=1312303304]
Ok lets start Denormalization?

Asalu Denormalization epudu use chestham? lets discuss on this first and then ela use cheyali anedhi discuss chedham ... emi antaru  sSa_j@il
[/quote]
Asalu denormalization ante enti?  sCo_^Y sCo_^Y

[Ranga_The_Donga]

[quote author=meghana9 link=topic=219396.msg2703109#msg2703109 date=1312303304]
Ok lets start Denormalization?

Asalu Denormalization epudu use chestham? lets discuss on this first and then ela use cheyali anedhi discuss chedham ... emi antaru  sSa_j@il
[/quote]

at times of heavy access load......

denormalization use chestharemo....... sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y

[Ranga_The_Donga]

[quote author=pulithoka link=topic=219396.msg2703122#msg2703122 date=1312303423]
Asalu denormalization ante enti?  sCo_^Y sCo_^Y
[/quote]

adding redundant data...

[pulithoka]

[quote author=Jeedeelu link=topic=219396.msg2703133#msg2703133 date=1312303487]
adding redundant data...
[/quote]
Konchem telugu lo chepthava  S%Hi S%Hi

[ronitreddy]

#~` #~` #~`

[cinema pichodu]

ikkada andaru ROCK bayya......ee thread susthunte edupu aapukoleka pothunna.........
*=: *=: *=: *=: *=: *=:
naaku oka doubt...........naaku basic queries thappa asalu em theleedhu....que mari silly ga untundemo em anukokandi..........

que : asalu oka table duplicate columns untaya......(i mean column name).......oka vela ala unte...insert column use chesinappudu data endulo insert avuthundi.........
s%H# s%H# s%H# s%H# s%H# s%H# s%H#

[Ranga_The_Donga]

[quote author=pulithoka link=topic=219396.msg2703140#msg2703140 date=1312303553]
Konchem telugu lo chepthava  S%Hi S%Hi
[/quote]

database lo fast ga data retrive cheyadaniki....chese process e denormalization.....otherwise performance tuning....