Viewing 15 posts - 1 through 15 (of 70 total)
Thank you for your input.
Having 1 Distributor server, is it then advised to have multiple distribution databases? For the multiple Subscribers?
Something like:
Server A = Publisher
Server B...
November 21, 2018 at 1:40 am
April 26, 2018 at 12:31 am
I have not made any changes to indexing on the subscriber/distributor - I only...
April 24, 2018 at 2:28 am
April 24, 2018 at 1:12 am
Hi,
One publisher server, 27 publications, One distribution database.
I think you could be right , because I have also noticed that when the CPU spikes on the Publisher,...
April 23, 2018 at 6:51 am
The changes they want to make is any Alteration on an existing table
eg. ALTER TABLE .... ALTER COLUMN....
or
ALTER TABLE... ADD ....
Their permissions are
...
February 1, 2018 at 3:06 am
We have dedicated support staff that can make these alteration - and yes it is all under change control. All changes are reviewed by me in any way. But I...
February 1, 2018 at 2:39 am
Yes he has restarted SSMS quite a few times and it still happens.... The strange thing is that this does not happen with all his queries. It seems random
September 29, 2017 at 5:59 am
Hi
I checked that - that is the autoCommit I was referring to... it aint ticked...
September 29, 2017 at 5:46 am
I would like to ask one more thing:
I am seeing a high ratio of Recompilation - on average over 50% of incoming batches and of Compilations per second.
How...
September 6, 2017 at 8:35 am
Thank you all for your replies and suggestions! Much appreciated!
September 5, 2017 at 2:10 am
Hi,
Thank you for your feedback, and for confirming my suspicions....
I inherited this server so the setup is not great:
* I fixed the maintenance processes with...
September 1, 2017 at 12:56 am
Nope, no maintenance plan, it is T-SQL code I created
April 12, 2017 at 2:17 am
With regards to the question of bulk load or spread out: it is spread out over the day.
April 11, 2017 at 11:31 pm
Viewing 15 posts - 1 through 15 (of 70 total)