Viewing 15 posts - 1 through 15 (of 110 total)
We have migrated to premium disk in Azure, now all running fine and faster.
Thanks all.
April 4, 2024 at 12:04 pm
Yes, it is duplicate post. I wrongly posted under replication section but that is for SQL 2000.
April 2, 2024 at 11:32 am
No , It is SQL 2014.
I do not see replication in 2014 , I have posted here.
March 27, 2024 at 12:18 pm
Thank your for your suggestion. Yes, All the drives are 4KB format only - Data , log etc.
I will check top duration query and will see to be indexed. I...
March 7, 2024 at 1:41 am
Thank you very much, This is very clear now.
December 1, 2023 at 2:44 pm
Thanks both for your response. It is standard edition, I have to check with business for enterprise for Always ON.
Sorry, It is purely for DR purpose. In case of anything...
November 30, 2023 at 1:39 pm
Thank you for your response. This will help me.
November 18, 2023 at 11:11 am
Thanks for the update. I am just trying to compare replication tables row count from publisher to subscriber. Thought of dynamically generate rowcount for all replicated tables both side and...
November 15, 2023 at 1:47 pm
Hi,
Thanks for your response. It is been configured like that and they need real time data with some other additional tables in the subscriber.
I am thinking to remove subscription and...
November 15, 2023 at 1:38 am
Hi,
I was trying some test. I wanted to get all replicated tables count to inserted to another table per publication. So that, I will cross check with publisher and subscriber.
November 15, 2023 at 1:36 am
Thanks Phil, good catch on the space. If there is no space I think it will be different function to use.
November 7, 2023 at 10:02 am
Hi ScottPletcher,
Thanks for the code. It is really helpful. I can see if the database does not have any backup after it is created is not showing. Anyway I...
November 2, 2023 at 3:35 pm
Hi ScottPletcher,
Can I add one more condition if the full backup is not happen in last 7 days, show me the database names.
Got it
FROM cte t
WHERE t.rn = 1
and backup_finish_date...
November 2, 2023 at 3:25 pm
Hi ScottPletcher,
Thanks for the code. It is really helpful. I can see if the database does not have any backup after it is created is not showing. Anyway I will...
November 2, 2023 at 2:20 pm
Viewing 15 posts - 1 through 15 (of 110 total)