its pretty easy to google, but this might help

https://mindmajix.com/sql-server-2019#sql-server

personally I like the inline function optimisation and the mongo db integration into poly, but I think you need to work out...

Can you create a unique index on the table?

is your Primary key correct ?

going to 2019  will bring you longer term benefits... you won't have to upgrade from 2017, so your upgrade lifecycle is less expensive, but you will have to put some...

I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company)...

I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) and hit...

Can you do something like sp_droparticle  in a loop and then clean it up at the end?

I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) and hit a wall...

OK, I think I missed the important question - 7000 articles, that is not good for transactional replication- the tlog will go bonkers. are there other options?

is it a push or pull subscription? and do you have a distributor at a different server or is it on the publisher? -

just trying to get a feel for...

we all made fun of your shirts

I offered to have an auction for them

I'm way out of my depth here (and I was only reading this because i'm doing the same thing.

The AG will take the database and the "User" but not the...

did you look to see if it was a locking issue?

Good to have you back dude. can you slap Grant around a bit, he keeps kicking my ass on XE vs profiler 🙂 he's almost converted me

I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) and hit a wall of pain...

I would recommend adding either a disk or file share to the 3-node cluster giving (by default) 4 votes.  Then - I would set the node weight of the...