Ms Sql Server Technology Discussions

[deals2buy]

[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

[gundugadu]

sample di previos post lo vunnay baaa chudu

[deals2buy]

[quote name='gundugadu' timestamp='1353343028' post='1302823100']
sample di previos post lo vunnay baaa chudu
[/quote]

sample di naaku ardham kaaledu..anduke adigaanu malli

[Desamudhuru]

[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

[Desamudhuru]

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 ??

[deals2buy]

[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?

[Desamudhuru]

[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

[gundugadu]

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

[deals2buy]

[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

[gundugadu]

[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

-----------------------------------------------------------------------------------------------

[Desamudhuru]

[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

[deals2buy]

[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

[gundugadu]

melcow baaaaaaaaaaaaa

[9Pardhu]

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

[deals2buy]

[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