deals2buy Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='gundugadu' timestamp='1353339743' post='1302822776'] neee issue yendi baaaa appudu view nundi flat file loki data pampali annav adenaaaaaaaaaaa enka solve kakapothe cheppu nenu code rasi pamputha BCP program lo [/quote] okasari aa BCP program script ikkada veyyi neneppudu BCP vaadaleu Link to comment Share on other sites More sharing options...
gundugadu Posted November 19, 2012 Report Share Posted November 19, 2012 sample di previos post lo vunnay baaa chudu Link to comment Share on other sites More sharing options...
deals2buy Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='gundugadu' timestamp='1353343028' post='1302823100'] sample di previos post lo vunnay baaa chudu [/quote] sample di naaku ardham kaaledu..anduke adigaanu malli Link to comment Share on other sites More sharing options...
Desamudhuru Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='deals2buy' timestamp='1353339713' post='1302822772'] jagratha vayya..nuvvu modhati job lo ne motham manager meedaki vadilesthe ela? inthaki manager telloda desi na? [/quote] thellodu vadiki kuda ardham kavadam ledu anni correct gane vunayi kani data enduku veladam ledu ani nannu asking vadu [quote name='gundugadu' timestamp='1353339743' post='1302822776'] neee issue yendi baaaa appudu view nundi flat file loki data pampali annav adenaaaaaaaaaaa enka solve kakapothe cheppu nenu code rasi pamputha BCP program lo [/quote] Koncham help chesi punyam katuko baaa plzzzzz Link to comment Share on other sites More sharing options...
Desamudhuru Posted November 19, 2012 Report Share Posted November 19, 2012 Inkoka problem kuda vochindi bhayya...... Nenu chepina VIEW server mida 48 Seconds lo execute ithondi na Local system mida almost 32 minutes thisukuntondi ???? Em problem iyi vuntudhi bhayya ?? Link to comment Share on other sites More sharing options...
deals2buy Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='Desamudhuru' timestamp='1353343371' post='1302823151'] thellodu vadiki kuda ardham kavadam ledu anni correct gane vunayi kani data enduku veladam ledu ani nannu asking vadu Koncham help chesi punyam katuko baaa plzzzzz [/quote] telloda? aithe ok...but jagratha ga manage cheyyi meeting ki pothunna...vachaka nee issue chusta [quote name='Desamudhuru' timestamp='1353343598' post='1302823179'] Inkoka problem kuda vochindi bhayya...... Nenu chepina VIEW server mida 48 Seconds lo execute ithondi na Local system mida almost 32 minutes thisukuntondi ???? Em problem iyi vuntudhi bhayya ?? [/quote] sever configuration veru untundi nee local system config veru untundi anukunta kadaa? Link to comment Share on other sites More sharing options...
Desamudhuru Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='deals2buy' timestamp='1353343909' post='1302823226'] sever configuration veru untundi nee local system config veru untundi anukunta kadaa? [/quote] Kani ma manager gadi local system lo 40 Sec ee patindi vadu check chesuko mannadu enduku query anta long time thisukuntundho ani Link to comment Share on other sites More sharing options...
gundugadu Posted November 19, 2012 Report Share Posted November 19, 2012 Sp_who2 active edi run cheyyi ekkada yekkuva time thesukuntundoo 45 mins annava ga akkadar un cheyyi two seperate wondows lo and yedina block/lock chesthundo ledo chudu and then yelanti blockings leka pothe the neee query ni eeeee code maylo petti execute cheyyi set statistics time on ----- SQL code here set statistics time OFF set statistics IO OFF hoepe u can find some thing Link to comment Share on other sites More sharing options...
deals2buy Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='gundugadu' timestamp='1353344504' post='1302823326'] Sp_who2 active edi run cheyyi ekkada yekkuva time thesukuntundoo 45 mins annava ga akkadar un cheyyi two seperate wondows lo and yedina block/lock chesthundo ledo chudu and then yelanti blockings leka pothe [b][color=#ff0000]the neee query ni eeeee code maylo petti execute cheyyi[/color][/b] set statistics time on ----- SQL code here set statistics time OFF set statistics IO OFF hoepe u can find some thing [/quote] ardham kaaledu mama..koddiga explain cheyyava Link to comment Share on other sites More sharing options...
gundugadu Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='deals2buy' timestamp='1353349768' post='1302823970'] ardham kaaledu mama..koddiga explain cheyyava [/quote] typo mistake adi ayana run cheya daluchukunna query ni pina mention chesa kada oka block SQL code dantlo padesi execute chesthe reads and write thelusthay enka veeze ga kavalante show actual execution plan optionn vundi lkada adi enable chesi query run chesthe table scans yemina vunte avi remove chesthe saripothundi ----------------------------------------------------------------------------------------------- set statistics time on set statistics IO on ---Enter the SQL code Here set statistics time OFF set statistics IO OFF ----------------------------------------------------------------------------------------------- Link to comment Share on other sites More sharing options...
Desamudhuru Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='gundugadu' timestamp='1353352795' post='1302824370'] typo mistake adi ayana run cheya daluchukunna query ni pina mention chesa kada oka block SQL code dantlo padesi execute chesthe reads and write thelusthay enka veeze ga kavalante show actual execution plan optionn vundi lkada adi enable chesi query run chesthe table scans yemina vunte avi remove chesthe saripothundi ----------------------------------------------------------------------------------------------- set statistics time on set statistics IO on ---Enter the SQL code Here set statistics time OFF set statistics IO OFF ----------------------------------------------------------------------------------------------- [/quote] Thnaksbaa figured something edo block chestondi.......... Thnaks a lot Yeraga thisesa Link to comment Share on other sites More sharing options...
deals2buy Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='gundugadu' timestamp='1353352795' post='1302824370'] typo mistake adi ayana run cheya daluchukunna query ni pina mention chesa kada oka block SQL code dantlo padesi execute chesthe reads and write thelusthay enka veeze ga kavalante show actual execution plan optionn vundi lkada adi enable chesi query run chesthe table scans yemina vunte avi remove chesthe saripothundi ----------------------------------------------------------------------------------------------- set statistics time on set statistics IO on ---Enter the SQL code Here set statistics time OFF set statistics IO OFF ----------------------------------------------------------------------------------------------- [/quote] ok ok... so much..learned many new things today becoz of u Link to comment Share on other sites More sharing options...
gundugadu Posted November 19, 2012 Report Share Posted November 19, 2012 melcow baaaaaaaaaaaaa Link to comment Share on other sites More sharing options...
9Pardhu Posted November 19, 2012 Author Report Share Posted November 19, 2012 last time evaro log file growth and truncation gurinchi adigaru here are details: You know there is always an issue - the log file growing very fast and big. If you have plenty of storage, then this might not be a problem for you. Anyway, this is no exception in the latest version of SQL, we still have to do something to truncate and shrink these files. Implementation Link to comment Share on other sites More sharing options...
deals2buy Posted November 19, 2012 Report Share Posted November 19, 2012 [quote name='9pardhu' timestamp='1353355745' post='1302824789'] last time evaro log file growth and truncation gurinchi adigaru here are details: You know there is always an issue - the log file growing very fast and big. If you have plenty of storage, then this might not be a problem for you. Anyway, this is no exception in the latest version of SQL, we still have to do something to truncate and shrink these files. Implementation [/quote] process kuda cheppu bhayya Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts