here's a thought, could it be possible to script up something  that re-initialises the subscriptions and runs the snapshot job when a DDL event occurs (e.g drop table)...

• This reply was modified 5 years, 8 months ago by MVDBA (Mike Vessey).

I suppose lmgtfy.com could be construed as "sarcastic"? but it is tempting sometimes.

Better to be a nice DBA and not discourage people trying to learn.

BAD DBA for even thinking about...

We frequently raffle off Steve's shirts at the Redgate Summit events. I'm sure that will continue. Although, for everyone's comfort, it's a shirt he is not wearing and hasn't...

here's a thought, could it be possible to script up something  that re-initialises the subscriptions and runs the snapshot job when a DDL event occurs (e.g drop table) you could...

I think there is an opportunity here - have a competition for one of Steve's shirts (I've seen the Redgate labelled Hawaiian shirt he wore in London)

if you have enough...

we had to drag info out of the original poster and Grant just googled "in memory open source" - ... i think he might have given up on...

Little bit of amusement for you all. Was going through some old processes, that out date me at the business, they're being "questioned" (aka, people have forgotten what they...

looks like this is Grant's winning argument to Extended events. , but I will advise that you need to know your hardware setup before you measure disk I/O and whether...

I'm doing to be honest here, it looks like you are looking for a solution before you know what the problem actually is... we can't help you without details

so you want open source - which means "free", beware of the licence- you may have to disclose your code which may be not in the interests of your company

as...

I would advise against running in high safety mode if possible (if your mirror server falls down then you can't commit transaction on the principal) - I've always run in...

since I couldn't see the bottom of the plan, very stupid question - are there any triggers on the table?

Occasionally in this scenario I've used a computed column (normally I persist it - PCC) that mimics your lookup values. once you get all of your code sorted (joins, views...

So, please, I hope, you're testing this in a non-production environment, because, here's a bit of fun trivia, once you mark a database as in-memory, you can never undo...

as I mentioned memory optimised tables need to be treated with care.

what are you trying to fix? have you got stats that suggest your issues?