Have you checked the primary is up and running correctly and that FCM can see both nodes?

Was the latest log restored? You could try to set hadr to resume and see if that helps.
https://www.brentozar.com/archive/2016/06/availability-group-direct-seeding-fix-database-wont-sync/

Its not applicable in this instance, the lock will always escalate on this kind of behaviour., the only thing you could try is set the transaction to snapshot, but your...

Set up a custom message in sys.messages, then set up an alert for that that emails the DBA team maybe..

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addmessage-transact-sql?view=sql-server-2017

The first thing to do is look at your data. Is there a reason for using TOP 1 all over the place? As the values are coming from Info and...

OK, Fieldvalues is what is in the buffer at the time of the deadlock happening, but as you have Fieldvalues in your stored procedure, it will be holding a lock...

Need a bit more information. Is this a new database you are trying to join or an existing? What does FCM say about the cluster/listener? If new, did you restore...

I am guessing you are asking this because the query is slow or you find it unreadable?
If the later, you can always just do multiple joins to the Info...

Thanks sergiy, after I posted this, I deleted and re-added the shares (added by someone else and at each level of the folder structure) and it fixed the issue. Very...

You are trying to delete from Questionnaire at the same time as you are trying to bulk insert, so yes, you will get a deadlock with an IX lock. The...

Never tried it, but recursive is different to nested in the respect of nested being more than one trigger, recursive means making a single trigger run more than once.

1. Nested triggers fire triggers on other tables, views etc, not on its own table, also as this is enabled in the configuration, it is something it is possible to...

If I understand correctly, I think you need to go to Ola's site and read the parameters, you don't need to use exactly the same clause, you can easily just...