Viewing 15 posts - 256 through 270 (of 1,999 total)
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)...
February 21, 2020 at 3:14 pm
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...
February 21, 2020 at 3:05 pm
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...
February 21, 2020 at 2:59 pm
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...
February 21, 2020 at 2:52 pm
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...
February 21, 2020 at 2:40 pm
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...
February 21, 2020 at 2:26 pm
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...
February 21, 2020 at 1:11 pm
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...
February 21, 2020 at 9:02 am
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
February 21, 2020 at 8:53 am
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...
February 21, 2020 at 8:51 am
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...
February 20, 2020 at 5:27 pm
since I couldn't see the bottom of the plan, very stupid question - are there any triggers on the table?
February 20, 2020 at 5:22 pm
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...
February 20, 2020 at 4:00 pm
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...
February 20, 2020 at 1:08 pm
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?
February 20, 2020 at 8:37 am
Viewing 15 posts - 256 through 270 (of 1,999 total)