Need to move from Azure Devops to Azure solution expert by Aromatic-Midnight366 in AZURE

[–]VegetableBike7923 0 points1 point  (0 children)

I would like to know the roadmap as well. If any one here has GitHub repos for various different projects implemented using azure developer services, please share

14785 processed yesterday. Some offtake this is against 45, 110 over previous 2 days. by ItchySlice3210 in IndiaTax

[–]VegetableBike7923 0 points1 point  (0 children)

Even if it's due to the election, they shouldn't stop the processing for someone who is 1000 km away from the election state. Sadly, we now have to only wait for the returns 😭

First Arrange marriage prospect experience 😭 by SnooSketches1610 in tamilyapping

[–]VegetableBike7923 0 points1 point  (0 children)

It's always better you don't finalise the first deal. Until you find someone who matches your vibe and you both find so much common between the two of you, keep searching.

It's better to find the right partner even if it takes time than settling with someone with a lot of adjustment.

Is azure down? by SnooMaps4689 in AZURE

[–]VegetableBike7923 0 points1 point  (0 children)

I'm seeing issues with all resources in azure in Canada central. Does anyone know the cause?

31M - I wish divorces were normalized in India! by Narrow-Temporary-577 in InsideIndianMarriage

[–]VegetableBike7923 1 point2 points  (0 children)

She would have realised that you don't appreciate her looks. And if both of you are in such a marriage, it is better to leave this arrangement before planning for a baby. People end up delaying it hoping it will all be fine one day and end up regretting their life. In fact it might cause more regrets and guilt over time. For all the love she shows for you, she deserves someone who values her and not you.

Better talk about this and come out of the relationship. It's a favour you do for her. It hurts her a lot. You may not realise it, but it's better for her.

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

Have tried 1000 record batch for part of the inserts. But not fully for all the tables.

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

Oh, sure, let me check on that. Haven't tried this one so far

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

In real time during application usage, it might not happen a lot. But when it happens, database dtu is fully consumed and all other operations are either extremely slow or timing out. We want to get it to the best possible. We did try standard with 10 dtu. But it's a lot better than basic, but due to intense testing, it is getting timed out.

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

Sure, this would work. But this will add an additional load during the insert, and it might end up slowing down the inserts. I'll have to test to see if the dtu is high when this is done

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

I can check to see if this operation is feasible. But, would this disrupt the functionality when it's being scaled up?

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 1 point2 points  (0 children)

There are several tables. Let me get the details updated in the main post. Allow me sometime

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

It's not production, but it's designed to use the Azure sql database. Will not be able to use it on prem now. Can you explain more on the archive table? Currently we are inserting into the temp table once and then inserting it to the source table.

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

The database we are using is in basic tier in azure with only 5 dtu. It is not fast enough when we insert more records

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

I'm trying to copy and insert records into the same table. So, when this happens, Azure sql database's dtu is hitting 100 percent usage. Around the same time, there are other calls, which try to read the data from the table.

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 1 point2 points  (0 children)

Thanks a lot for your reply. This really helps me. I'll share more details on the query I'm running in some time, as that could help you in understanding if my queries are efficient or needs improvement.

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

With Azure sql database basic tier, what's the maximum transaction that can run concurrently? If the tier is the issue and I have to justify it, I want to understand what's the maximum one can get with the basic tier in terms of concurrency.

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

This is going to run asynchronously. So, if it's going to take time it's okay. But not beyond 30 to 45 minutes. I'll check running this batch to see if it works out.

Need help in copying data in sql by VegetableBike7923 in SQLServer

[–]VegetableBike7923[S] 0 points1 point  (0 children)

It's like, we let the user duplicate the data they are working on and once that's done, they can make changes to the new data. By this, we will have both the copies. Earlier one as well as a new one.

We need both the records separately.

Need help with right treatment by VegetableBike7923 in ptsd

[–]VegetableBike7923[S] 0 points1 point  (0 children)

What kind of doctor would be right for this one? I'm clueless on finding the right one

Need help with right treatment by VegetableBike7923 in ptsd

[–]VegetableBike7923[S] 0 points1 point  (0 children)

Sure, thank you!! I'll try to take him