you are welcome, and besides sql azure topics are always interesting.

best regards,

tonci korsano

hi there,

i just found out there is no sql agent in sql azure.

so to run scheduled sql code in sql azure, you need a windows azure worker role.

this link

-->

i forgot to say something very important.

i apologize for all inaccuracies i have written in this thread, as these inaccuracies might mislead to wrong conclusions, which goes against the purpose...

i am sure you are right because i saw it.

maybe if a table is about 167 millions of rows, which i saw happening, then it takes more than a second.

so,...

hi there,

here is the answer --> https://www.google.com/#hl=en&sa=X&psj=1&ei=70OtT53nCYKy8ASUwrWXDQ&ved=0CBgQvwUoAQ&q=(sqlbulkcopy+OR+bcp)+(%22no+logging%22+OR+%22does+not+log%22)&spell=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&fp=356e729b7a15c7f0&biw=1280&bih=891

or just put in google.com

(sqlbulkcopy OR bcp) ("no logging" OR "does not log")

this is really a web search... even though it...

hi there,

your suggestions are all fine.

bulk copy is always fast because it doesn't log (it is like saying it doesn't use the transaction log). so, if the issue is not...

hi there,

please, make this google saved search:

sqldatareader vs dataset performance

you could try sqldatareader.

it uses a server-side cursor.

you have to close your sqldatareader object once you are finished with it.

scrolling of...

hi there,

i know about round robin because of chess tournaments.

it is like everybody against everybody, but in chess is double turn because once you play as white and one more...

hi there,

instead of concatenating your strings with str1 +=, use stringbuilder class.

in this way, you will shorten execution time.

here are examples of using stringbuilder class: http://www.google.com/#sclient=psy&hl=en&biw=1280&bih=899&source=hp&q=stringbuilder+.net+example+c%23&aq=f&aqi=&aql=&oq=&pbx=1&bav=on.2,or.r_gc.r_pw.&fp=f6843edb09e9953a

good luck,

tonci korsano

hi again,

i haven't used sqldecimal ever, but if precision property didn't work, you might want to try method SqlDecimal.ConvertToPrecScale() in your return value.

here is an example of this method -->...

hi there,

you might want to try this --> [Microsoft.SqlServer.Server.SqlFacet(Precision = 18, Scale = 2)]SqlDecimal val, [Microsoft.SqlServer.Server.SqlFacet(Precision = 18, Scale = 2)]SqlDecimal nullVal

i haven't ever tried this, but sqldecima data type...

hi there,

maybe your assembly is supposed to go inside "program files (x86)" folder.

maybe you need to build that assembly project, with visual studio, to target x64 environment in a separate...

hi there,

i think that option might be under -o switch.

something like -oConnectTimeout=<a whole number>.

i haven't used sftp though, but i can see this in man from linux, like --> man...

i guess it can be done from a ssis package with a script task and replace method of string class.

best regards,

tonci.

hi arshad,

we are already using the same logic you explained for sql server 2005.

we don't have sql server 2000, so we don't have to call a stored procedure recursively.

we have...