Your real problem there is RyanAir,...

I have a flight to Poland in a few weeks.. fingers crossed Ryanair can get me there and back before work on monday

ok - have you tried using scripting

sp_addpublication

sp_addarticle

sp_addsubscription

see if it's an issue on the UI

script it from live and run it bit by bit. replication code is not difficult - once...

we're writing up a plan for using kubernetes, docker and lambda functions in AWS (not a live product yet) - I'm looking forward to it

- ktflash , these are 100%...

Heh... I know... big surprise there, right? 😀

The total time taken...

...I think the potential irony of the whole mess is that fewer people are flying, so the airlines aren't making as much money. After the fighting in both...

Maybe the answer is much simpler...

Will it be the DBA or the Developer that gets woken up at 3:00am because the application is slow/not working?  That person can...

Hehe...  the worst part is the same thing happened like a year ago, but it's been fine since we did the firewall changes...  they just forgot to apply them...

We have had failures in the past due to networking issues, but those have always been caught.  I am trying to figure out how this time the inserts...

Ignoring the politics, this is interesting: https://www.cnn.com/2020/03/09/politics/coronavirus-airlines-white-house-tensions/index.html

US govt: we want this data

CEO: We don't have that

US govt: You're lying.

CEO: We can collect it with paper, or build an...

on floor laughing... steal that plaque and post it to me.

I can just imagine that as the front bit of a box that contains an instant database that is fully...

work from the top right of your plan - try and get rid of that scan on balancetable (it's in a few places and might completely adjust your plan) -...

are you using availability groups?

I've seen this before while testing

https://support.microsoft.com/en-gb/help/4092554/errors-627-or-12324-occur-when-cross-database-transactions-are-promote

so , some tables got partial data? are you using SSIS? i'm kinda going down the "batch size" route.. maybe incorrectly

not sure why you aren't getting an error, but you...

for unit testing of database code then Redgate has SQL Test, It's fairly cool and has a code coverage calculator (so that you can tell your boss that you tested...