Hey SSIS medha evaraina work chesthunnara...need some help plzzz

[nenuinthe]

[quote author=chelsea link=topic=152970.msg1793844#msg1793844 date=1297129681]
thankyou thankyou thankyou  you rock you rock you rock ba emi anna doubts vuntei will pm you ba sHa_high5ing sHa_high5ing sHa_fr1ends
[/quote]ok baa np  sHa_high5ing sHa_high5ing sHa_fr1ends sHa_fr1ends[quote author=manoghna link=topic=152970.msg1793864#msg1793864 date=1297129797]
thankyou thankyou .. ur working only on SSIS ?

stored procedure performance tuning chesara?
naku telisinavi ivi correct o kadho chepandi if u have idea....

we need to check whether the query contains any subqueries ..if so we need to minimize those subqueries and try to get the result using joins that too avoid using outerjoins.

next we need to use NOCOUNT ON and update statics on

we need to delete un necessary Indexes and need to create indexes on frequently used columns in where condition.

when ever modifications done on table need to update statistics...

ivi kakunda inkemaina use chesthara stored procedure tuning ki?
[/quote]chestaru kani peddaga nenu cheyyaledu anni statistics run cheyyatam lantivi cheyyaledu index is main thing...u already got that point..... unnecessary tiyyatam... necessary vi create kuda chesukovali.....ilantivi anni best google.... sSa_j@il sSa_j@il

[chelsea]

[quote author=manoghna link=topic=152970.msg1793899#msg1793899 date=1297130059]
all the best for u too..  sHa_high5ing sHa_high5ing
midhi already oka project aipoindha ?
[/quote]
  thankyou yeah i have done one project in ssrs for 4 months  sHa_high5ing

[nenuinthe]

Ok Guys ATB ...Gud Luck..... ~"! ~"! ~"!

[manoghna]

[quote author=BEZAWADA ROWDY link=topic=152970.msg1793927#msg1793927 date=1297130218]
ok baa np  sHa_high5ing sHa_high5ing sHa_fr1ends sHa_fr1endschestaru kani peddaga nenu cheyyaledu anni statistics run cheyyatam lantivi cheyyaledu index is main thing...u already got that point..... unnecessary tiyyatam... necessary vi create kuda chesukovali.....ilantivi anni best google.... sSa_j@il sSa_j@il
[/quote]ok  thankyou thankyou thankyou so much for clarifying my doudts..  you rock ur replies are very useful to me..thank u once again...  g0ssIp

[chelsea]

[quote author=BEZAWADA ROWDY link=topic=152970.msg1793972#msg1793972 date=1297130427]
Ok Guys ATB ...Gud Luck..... ~"! ~"! ~"!
[/quote]
thankyou thankyou ba  sHa_high5ing sHa_fr1ends

[Bairagi From Bapatla]

babu babu panilo pani DTS pkgs vachina vallu unte kuda cheppandayya... maa dhantlo sql 2000 ee vaduthunaru...

[nenuinthe]

[quote author=Bairagi From Bapatla link=topic=152970.msg1794118#msg1794118 date=1297131340]
babu babu panilo pani DTS pkgs vachina vallu unte kuda cheppandayya... maa dhantlo sql 2000 ee vaduthunaru...
[/quote][img]http://img123.imageshack.us/img123/615/umeddco1.gif[/img] 2008 nadi

[Bairagi From Bapatla]

[quote author=BEZAWADA ROWDY link=topic=152970.msg1794146#msg1794146 date=1297131523]
[img]http://img123.imageshack.us/img123/615/umeddco1.gif[/img] 2008 nadi
[/quote]

ok baaa

[sqlserver]

mama SSRS & SSIS meda Interview questions unte pampara konchem....

[manoghna]

[quote author=sqlserver link=topic=152970.msg1794777#msg1794777 date=1297136569]
mama SSRS & SSIS meda Interview questions unte pampara konchem....
[/quote]repu morning pampisthanu na degara vunnavi...google lo kooda chala vuntai oka sari chudandi...take care  sHa_high5ing

[vaasu]

maa office lo reports generation kosam separate database use chesevallam.
main database nunchi reports database ki daily basis lo data transfer cheyyadaniki ssis use chesthunam.

[Rising star]

[quote author=manoghna link=topic=152970.msg1793864#msg1793864 date=1297129797]
thankyou thankyou .. ur working only on SSIS ?

stored procedure performance tuning chesara?
naku telisinavi ivi correct o kadho chepandi if u have idea....

we need to check whether the query contains any subqueries ..if so we need to minimize those subqueries and try to get the result using joins that too avoid using outerjoins.

next we need to use NOCOUNT ON and update statics on

we need to delete un necessary Indexes and need to create indexes on frequently used columns in where condition.

when ever modifications done on table need to update statistics...

ivi kakunda inkemaina use chesthara stored procedure tuning ki?
[/quote]may be you know this, but performance tuning chese mundhu Execution plan chusthamu procedure di, then will decide which table/join has issues... primarily joins lo issues untai... ledhante on indexing...

outer joins are costly... but necessary if the requirement demands....  inner joins mundu use cheyadam better so that result wil reduce for next outer joins.... and also specific condition unte better to use in inner join itself...

for ex: select a.col1, b.col2, c.col3
          from a left outer join b
            on        a.col1 = b.col1
          inner join c
            on a.col1 = c.col2
        where a.col1 = 21
       
better way, use inner join first and condition within join

  select a.col1, b.col2, c.col3
          from a inner join c
            on        a.col1 = c.col2 and
                    a.col1 = 21    ( rows chala filter aipothai in this join itself)
          left outer join b
            on a.col1 = b.col1

ordering of joins and not deviating the requirement also plays a role in performance.

PS: if u think my explanation is over, pls excuse me... i am  sorry2 sorry2 sorry2

[nenuinthe]

[quote author=Rising star link=topic=152970.msg1794871#msg1794871 date=1297137340]
may be you know this, but performance tuning chese mundhu Execution plan chusthamu procedure di, then will decide which table/join has issues... primarily joins lo issues untai... ledhante on indexing...

outer joins are costly... but necessary if the requirement demands....  inner joins mundu use cheyadam better so that result wil reduce for next outer joins.... and also specific condition unte better to use in inner join itself...

for ex: select a.col1, b.col2, c.col3
          from a left outer join b
            on        a.col1 = b.col1
          inner join c
            on a.col1 = c.col2
        where a.col1 = 21
       
better way, use inner join first and condition within join

  select a.col1, b.col2, c.col3
          from a inner join c
            on        a.col1 = c.col2 and
                    a.col1 = 21    ( rows chala filter aipothai in this join itself)
          left outer join b
            on a.col1 = b.col1

ordering of joins and not deviating the requirement also plays a role in performance.

PS: if u think my explanation is over, pls excuse me... i am  sorry2 sorry2 sorry2
[/quote] *=: you rock

[Rising star]

[quote author=BEZAWADA ROWDY link=topic=152970.msg1794883#msg1794883 date=1297137426]
*=: you rock
[/quote] thankyou thankyou mama...  sHa_fr1ends sHa_fr1ends sHa_high5ing sHa_high5ing

[vaasu]

[quote author=Rising star link=topic=152970.msg1794871#msg1794871 date=1297137340]
may be you know this, but performance tuning chese mundhu Execution plan chusthamu procedure di, then will decide which table/join has issues... primarily joins lo issues untai... ledhante on indexing...

outer joins are costly... but necessary if the requirement demands....  inner joins mundu use cheyadam better so that result wil reduce for next outer joins.... and also specific condition unte better to use in inner join itself...

for ex: select a.col1, b.col2, c.col3
          from a left outer join b
            on        a.col1 = b.col1
          inner join c
            on a.col1 = c.col2
        where a.col1 = 21
       
better way, use inner join first and condition within join

  select a.col1, b.col2, c.col3
          from a inner join c
            on        a.col1 = c.col2 and
                    a.col1 = 21    ( rows chala filter aipothai in this join itself)
          left outer join b
            on a.col1 = b.col1

ordering of joins and not deviating the requirement also plays a role in performance.

PS: if u think my explanation is over, pls excuse me... i am  sorry2 sorry2 sorry2
[/quote]
*=: *=: *=: