Ms Sql Server Technology Discussions

[kumargadu]

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 ?

[deals2buy]

evaraina unnnara?

BULK INSERT lo WHERE clause use cheyyalema?

[loveindia]

[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

[deals2buy]

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

[loveindia]

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

[loveindia]

@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...

[deals2buy]

[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

[loveindia]

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

[deals2buy]

[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

[loveindia]

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

[deals2buy]

[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

[loveindia]

[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

[littlemoon]

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

[loveindia]

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

[Darling999]

[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