kumargadu Posted April 10, 2013 Report Share Posted April 10, 2013 DBA's need some advice . C drive on my SQL server is almost full C drive is 64 Gb ( in that pagefile.Sys is occupying 32 Gb , Any idea how to handle this ? Link to comment Share on other sites More sharing options...
deals2buy Posted April 10, 2013 Report Share Posted April 10, 2013 evaraina unnnara? BULK INSERT lo WHERE clause use cheyyalema? Link to comment Share on other sites More sharing options...
loveindia Posted April 10, 2013 Report Share Posted April 10, 2013 [quote name='Kaarthikeya' timestamp='1365619019' post='1303578610'] evaraina unnnara? BULK INSERT lo WHERE clause use cheyyalema? [/quote] never tried, but read there is a turn around to do that... direct ga aitey not possible... http://msdn.microsoft.com/en-us/library/ms179250.aspx http://msdn.microsoft.com/en-us/library/ms190312.aspx -- see last Link to comment Share on other sites More sharing options...
deals2buy Posted April 10, 2013 Report Share Posted April 10, 2013 [quote name='loveindia' timestamp='1365620367' post='1303578832'] never tried, but read there is a turn around to do that... direct ga aitey not possible... [url="http://msdn.microsoft.com/en-us/library/ms179250.aspx"]http://msdn.microsof...y/ms179250.aspx[/url] [url="http://msdn.microsoft.com/en-us/library/ms190312.aspx"]http://msdn.microsof...y/ms190312.aspx[/url] -- see last [/quote] ivi rendu naaku telusu mama.....naa requirement diff which is to deal with rows and not columns nenu intha mundu cheppinattu...when I load data from a file to a database...cant I eliminate records that I don't want in a text fle before loading them into database? Link to comment Share on other sites More sharing options...
loveindia Posted April 10, 2013 Report Share Posted April 10, 2013 [quote name='Kaarthikeya' timestamp='1365627347' post='1303579822'] ivi rendu naaku telusu mama.....naa requirement diff which is to deal with rows and not columns nenu intha mundu cheppinattu...when I load data from a file to a database...cant I eliminate records that I don't want in a text fle before loading them into database? [/quote] no idea.. SSIS lo you can I believe, BULK Import lo no idea... Link to comment Share on other sites More sharing options...
loveindia Posted April 10, 2013 Report Share Posted April 10, 2013 @above all, intaku mundu evaro asked regarding transactions in SSIS. This is how we do it. First enable MSDTC in services or else you cannot do it. Then go to properties of each data flow task or package level and change the Transaction Properties to Required. And there you go, you have enabled transactions in your dataload package which rollsback automatically if anything went wrong. -- Test before you do anything.. -- In God We Believe All others must write SQL... Link to comment Share on other sites More sharing options...
deals2buy Posted April 11, 2013 Report Share Posted April 11, 2013 [quote name='loveindia' timestamp='1365628565' post='1303579961'] no idea.. SSIS lo you can I believe, BULK Import lo no idea... [/quote] SSIS lo can ante...script task use chesaa? if so, adi naaku telusu...but I want something in SQL [quote name='loveindia' timestamp='1365628823' post='1303579995'] @above all, intaku mundu evaro asked regarding transactions in SSIS. This is how we do it. First enable MSDTC in services or else you cannot do it. Then go to properties of each data flow task or package level and change the Transaction Properties to Required. And there you go, you have enabled transactions in your dataload package which rollsback automatically if anything went wrong. -- Test before you do anything.. -- In God We Believe All others must write SQL... [/quote] prati data flow lo maarchaali ante its a painful thing kadaa..can't we do it on a whole? btw GP Link to comment Share on other sites More sharing options...
loveindia Posted April 11, 2013 Report Share Posted April 11, 2013 [quote name='loveindia' timestamp='1365628823' post='1303579995'] @above all, intaku mundu evaro asked regarding transactions in SSIS. This is how we do it. First enable MSDTC in services or else you cannot do it. Then go to properties of[color=#ff0000][b][size=5] each data flow task or package level[/size][/b][/color] and change the Transaction Properties to Required. And there you go, you have enabled transactions in your dataload package which rollsback automatically if anything went wrong. -- Test before you do anything.. -- In God We Believe All others must write SQL... [/quote] Just read it man... thats it.. Link to comment Share on other sites More sharing options...
deals2buy Posted April 11, 2013 Report Share Posted April 11, 2013 [quote name='loveindia' timestamp='1365692860' post='1303583628'] Just read it man... thats it.. [/quote] ante ippudu naa daggara 70 packages unnayi...nuvvu cheppina daani prakaaram annitiki maarchaali kadaa Link to comment Share on other sites More sharing options...
loveindia Posted April 11, 2013 Report Share Posted April 11, 2013 [quote name='Kaarthikeya' timestamp='1365693081' post='1303583659'] ante ippudu naa daggara 70 packages unnayi...nuvvu cheppina daani prakaaram annitiki maarchaali kadaa [/quote] package marchakunda functionality available lo kaavali antaadu veedu evadandii babuuuuuuuu....... Link to comment Share on other sites More sharing options...
deals2buy Posted April 11, 2013 Report Share Posted April 11, 2013 [quote name='loveindia' timestamp='1365693233' post='1303583676'] package marchakunda functionality available lo kaavali antaadu veedu evadandii babuuuuuuuu....... [/quote]adi kaadu bhayya....global ga change chese option untunda annitki okate saari ani asking nenu ardham kakapothe lite lelo Link to comment Share on other sites More sharing options...
loveindia Posted April 11, 2013 Report Share Posted April 11, 2013 [quote name='Kaarthikeya' timestamp='1365693674' post='1303583725'] adi kaadu bhayya....global ga change chese option untunda annitki okate saari ani asking nenu ardham kakapothe lite lelo [/quote] ardham aindi le... manaki kaavalsinavi anni levu 2008R2 lo varaku aitey... 2012 emo mari naaku telidu.. ekkuva use cheyaledu inka... neeku nenu emanna sarcasm chesinattu anpistey.. jk Link to comment Share on other sites More sharing options...
littlemoon Posted April 11, 2013 Report Share Posted April 11, 2013 [quote name='kumargadu' timestamp='1365602261' post='1303576404'] DBA's need some advice . C drive on my SQL server is almost full C drive is 64 Gb ( in that pagefile.Sys is occupying 32 Gb , Any idea how to handle this ? [/quote] computer -> properties -> advanced settings ->performance ki velli automatic manage page file settings ni uncheck chesi select the size u want.. this shd help .. also how to manage virtual page file size midha articles untayi go through.. Link to comment Share on other sites More sharing options...
loveindia Posted April 11, 2013 Report Share Posted April 11, 2013 [quote name='littlemoon' timestamp='1365693990' post='1303583776'] computer -> properties -> advanced settings ->performance ki velli automatic manage page file settings ni uncheck chesi select the size u want.. this shd help .. also how to manage virtual page file size midha articles untayi go through.. [/quote] hi littlemoon, nuvvu maga dba's aa aada dev's aa??? Link to comment Share on other sites More sharing options...
Darling999 Posted April 11, 2013 Report Share Posted April 11, 2013 [quote name='Kaarthikeya' timestamp='1365693081' post='1303583659'] ante ippudu naa daggara 70 packages unnayi...nuvvu cheppina daani prakaaram annitiki maarchaali kadaa [/quote] anni packages ki maarchi teeralsindey. package creation appudey cheyyalsinaa pani idi. Development ayyaka chestey kashtam avtundi manual ga no. of packages ki maarachaali Link to comment Share on other sites More sharing options...
-1.thumb.png.613bdd33b4e8b5f69ac815bf90e62a8b.png)
Recommended Posts