• Since the db is already Tared and feathered, I guess the only approach is to pluck the feathers off one by one before hosing down the global settings. Each module/object must be evaluated as the settings can and will change the behavior, not only within the module but also in any dependents.

    I would consider FK's indices and trusted constraints a higher priority, as it will lower the deadlocking.

    😎