manoghna Posted February 8, 2011 Author Report Posted February 8, 2011 [quote author=BEZAWADA ROWDY link=topic=152970.msg1793624#msg1793624 date=1297128042]yup miru anukunedi crrct e.....avi load cheyyalante job e schedule cheyyakarledu.......mamuluga kuda run chesina avutayi....teliste ok... sHa_high5ing sHa_high5ing[/quote]ok and stored procedures use chese secaniors ila vundocha ..like data ki changes chese apudu ala...leka inka vere different scenario lo use chesthama? for ex:- using stored proc we can get data from the source table and trasfer it to the destination .....
chelsea Posted February 8, 2011 Report Posted February 8, 2011 [quote author=manoghna link=topic=152970.msg1793622#msg1793622 date=1297128026]am doing good..how ru?sql developer with ssrs and ssis ...[/quote]i am fine manoghna thankyou do u have any real time experience are u looking for your first project sHa_high5ing
manoghna Posted February 8, 2011 Author Report Posted February 8, 2011 [quote author=chelsea link=topic=152970.msg1793675#msg1793675 date=1297128428]i am fine manoghna thankyou do u have any real time experience are u looking for your first project sHa_high5ing[/quote]idhe first andhuke inni doudts vasthunnai ..
chelsea Posted February 8, 2011 Report Posted February 8, 2011 [quote author=Discussion link=topic=152970.msg1793633#msg1793633 date=1297128118]5n mama..how u sHa_fr1ends[/quote]i am good ba emti ba asalu peddaga ravataledu enduku missing your gif timing ba
idiot538 Posted February 8, 2011 Report Posted February 8, 2011 Vamoo inka doubts ayinatu levu gaa [img]https://lh3.googleusercontent.com/_vGgr3WUJEdg/TK4XQ5jl_cI/AAAAAAAAD7E/0SmP9ksVG58/Pawann%20%284%29.gif[/img]
chelsea Posted February 8, 2011 Report Posted February 8, 2011 [quote author=manoghna link=topic=152970.msg1793685#msg1793685 date=1297128483]idhe first andhuke inni doudts vasthunnai ..[/quote]ATB sHa_high5ing sHa_high5ing
manoghna Posted February 8, 2011 Author Report Posted February 8, 2011 [quote author=manoghna link=topic=152970.msg1793652#msg1793652 date=1297128292]ok and stored procedures use chese secaniors ila vundocha ..like data ki changes chese apudu ala...leka inka vere different scenario lo use chesthama? for ex:- using stored proc we can get data from the source table and trasfer it to the destination .....[/quote] sCo_hmmthink sCo_hmmthink sCo_hmmthink
nenuinthe Posted February 8, 2011 Report Posted February 8, 2011 [quote author=manoghna link=topic=152970.msg1793652#msg1793652 date=1297128292]ok and stored procedures use chese secaniors ila vundocha ..like data ki changes chese apudu ala...leka inka vere different scenario lo use chesthama? for ex:- using stored proc we can get data from the source table and trasfer it to the destination .....[/quote]raw files nundi vache tappudu mostly data conversion use chestam....conversions kosam use cheyyam.....Stored procs.....some thing like calculations......various joins on different tables and bring data....some things like that
chelsea Posted February 8, 2011 Report Posted February 8, 2011 [quote author=BEZAWADA ROWDY link=topic=152970.msg1793713#msg1793713 date=1297128686]raw files nundi vache tappudu mostly data conversion use chestam....conversions kosam use cheyyam.....Stored procs.....some thing like calculations......various joins on different tables and bring data....some things like that[/quote]ba raw flies ante emti ba flat files, excel files a sCo_hmmthink sCo_hmmthink ba nuvu eppudu ayyina oracle nuchi kani db2 nuchi kani data transfer cheyysava . chesthe elanti problems vachinavi sorry for asking to many questions when i go for f2f interview they ask me this question ba anduke
manoghna Posted February 8, 2011 Author Report Posted February 8, 2011 [quote author=BEZAWADA ROWDY link=topic=152970.msg1793713#msg1793713 date=1297128686]raw files nundi vache tappudu mostly data conversion use chestam....conversions kosam use cheyyam.....Stored procs.....some thing like calculations......various joins on different tables and bring data....some things like that[/quote]ssis package tuning gurinchi emaina idea vundha ..miru chesara idhi?
nenuinthe Posted February 8, 2011 Report Posted February 8, 2011 [quote author=chelsea link=topic=152970.msg1793745#msg1793745 date=1297128920]ba raw flies ante emti ba flat files, excel files a sCo_hmmthink sCo_hmmthink ba nuvu eppudu ayyina oracle nuchi kani db2 nuchi kani data transfer cheyysava . chesthe elanti problems vachinavi sorry for asking to many questions when i go for f2f interview they ask me this question ba anduke[/quote]sorry enduku baa naku peddaga pani pata ledu...edo youtube lo videos chustuna @3$% @3$%Raw Files emina avvachu.....Flat or xcel or cvs or xml any thing....inka nenu mottam SQL Sever mide chesanu no other database...avi google cheyyi baa....4 points paper lo rasukuni evadu adigina ave cheppu
nenuinthe Posted February 8, 2011 Report Posted February 8, 2011 [quote author=manoghna link=topic=152970.msg1793769#msg1793769 date=1297129085]ssis package tuning gurinchi emaina idea vundha ..miru chesara idhi?[/quote]e article chudu the best and easy ssis tuning[url=http://msdn.microsoft.com/en-us/library/dd537533(v=sql.100).aspx]http://msdn.microsoft.com/en-us/library/dd537533(v=sql.100).aspx[/url]
chelsea Posted February 8, 2011 Report Posted February 8, 2011 [quote author=BEZAWADA ROWDY link=topic=152970.msg1793772#msg1793772 date=1297129131]sorry enduku baa naku peddaga pani pata ledu...edo youtube lo videos chustuna @3$% @3$%Raw Files emina avvachu.....Flat or xcel or cvs or xml any thing....inka nenu mottam SQL Sever mide chesanu no other database...avi google cheyyi baa....4 points paper lo rasukuni evadu adigina ave cheppu[/quote] thankyou thankyou thankyou you rock you rock you rock ba emi anna doubts vuntei will pm you ba sHa_high5ing sHa_high5ing sHa_fr1ends
manoghna Posted February 8, 2011 Author Report Posted February 8, 2011 [quote author=BEZAWADA ROWDY link=topic=152970.msg1793784#msg1793784 date=1297129240]e article chudu the best and easy ssis tuning[url=http://msdn.microsoft.com/en-us/library/dd537533(v=sql.100).aspx]http://msdn.microsoft.com/en-us/library/dd537533(v=sql.100).aspx[/url][/quote] 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 onwe 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?
manoghna Posted February 8, 2011 Author Report Posted February 8, 2011 [quote author=chelsea link=topic=152970.msg1793701#msg1793701 date=1297128607]ATB sHa_high5ing sHa_high5ing[/quote]all the best for u too.. sHa_high5ing sHa_high5ingmidhi already oka project aipoindha ?
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts