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...

because temp tables are transient you will really have to catch this exactly as it creates the problem.

I might think about monitoring tempdb for any table over 5GB (a guess)...

trust me , i'm already shuddering - i'm asking because I want to get it right 🙂

so this is really cool info and so much better explained that msdn. I can't go up to 4 nodes, so would you recommend I drop down 2  rather than...

I'm being thick here  - (that happens a lot), but why does an odd number of nodes not help? I'm more of a query plan guy and I've been dumped...