Thanks very much ED, this give very good starting point for me to try and test.

I have test with range right. The main aim is to delete old data that...

Hi frederico fonseca,

Here is the original plan for onw of long run SP not the one I mentioned in the post. https://www.brentozar.com/pastetheplan/?id=SycJlfMyJe

Here is my test with 100M data...

Thanks Steve Collins for your response and time.

I have less development knowledge. I have tested it out with 100 million data load and deleted and update individual ad-hoc statements. update ...

We have migrated to premium disk in Azure, now all running fine and faster.

Thanks all.

Yes, it is duplicate post. I wrongly posted under replication section but that is for SQL 2000.

No , It is SQL 2014.

I do not see replication in 2014 , I have posted here.

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

Thank you very much, This is very clear now.

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

Thank you for your response. This will help me.

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

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

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.

Thank you ScottPletcher.

Thanks Phil,  good catch on the space. If there is no space I think it will be different function to use.

• This reply was modified 1 year, 1 month ago by  Saran.