Viewing 15 posts - 631 through 645 (of 2,661 total)
spam - exact copy of https://www.reddit.com/r/AZURE/comments/sb09bg/azure_pricing_sql_server_seems_pretty_high/ from Jan 2022
January 9, 2023 at 6:15 pm
without the full code (insert + table ddl) its not possible to state the exact issue - but I would guess the order of the columns being inserted do not...
January 9, 2023 at 5:08 pm
CR LF is breaking my data load into mysql, I have updated CR LF as space ' ' and load is working good.
it is not breaking it - you...
January 9, 2023 at 5:05 pm
I thought of using quotename. select * is not working some places found that because of CR LF.
select * does NOT CARE about CRLF - other than the thread...
January 9, 2023 at 10:00 am
but why do that update? if the data is there it likely has a good reason for it and should not be changed on a whim. (specially not if it...
January 9, 2023 at 9:58 am
HI,
fields terminated by "|" (the delimiter you used above), enclosed by '"' escaped by '"'
I have used the same test. But wherever there is a split it load as...
January 6, 2023 at 9:08 am
Thanks for the CR LF note, I am trying to bcp out from mssql and load to mysql.
if that is the case then doing what I stated is what...
January 5, 2023 at 4:56 pm
reason why you have your records split like that is because the data on those columns contain a CR or a LF or both - in order to be able...
January 5, 2023 at 9:09 am
you have already been given the answer to your last (and prior questions) - if they are above your head then consider hiring a professional (as you have been advised...
January 4, 2023 at 8:49 pm
you made it clear that you do not wish the job to run on the first of the month if it it is on a Sunday - but what do...
January 3, 2023 at 7:42 pm
spam - exact copy of https://www.reddit.com/r/aws/comments/100je4m/step_functions_trigger_rule/
January 2, 2023 at 10:59 am
Is this solution is only good if there are no dates falling on weekends?
what mention of weekends? there is nothing on the original OP post that mentions...
December 31, 2022 at 5:20 pm
Is this solution is only good if there are no dates falling on weekends?
what mention of weekends? there is nothing on the original OP post that mentions it neither...
December 31, 2022 at 3:00 pm
To be absolutely clear, you want a:
2) unique clustered [index] on (tenant,year,id)
And if you partition the data (which typically wouldn't be necessary here), partition it...
December 30, 2022 at 11:46 pm
@frederico_fonseca I apologize, I missed that you were doing a recursive loop there. My bad.
don't worry about it.
December 30, 2022 at 8:20 pm
Viewing 15 posts - 631 through 645 (of 2,661 total)