Consumable test data:

CREATE TABLE #t
(
    ID int NOT NULL
    ,Client_ID int NOT NULL
    ,MaxAmount money NOT NULL
);
INSERT INTO #t
VALUES (1, 234, 0)
,(1, 856,...

WITH OrderedOT_DTL
AS
(
    SELECT *
        -- You may have a column value you prefer to keep. (SELECT NULL) just orders as read.
        ,ROW_NUMBER() OVER (PARTITION BY ID, SDATE...

I was thinking of foreign key lookups in a high transaction environment.

If the PK on the lookup table is the clustered index then a lot of deadlocks can...

A bit a long shot, but you could try creating an unique constraint on the PK as well.

ALTER TABLE dbo.SalBranch
ADD CONSTRAINT UQ_SalBranch_Branch UNIQUE (Branch);


Just found this in Ola's FAQs:

Does the SQL Server Maintenance Solution support log shipping?

The SQL Server Maintenance Solution supports log shipping. Full and differential backup,...

I think, by default, Ola's scripts check for MS log shipping and will not do a log backup for those DBs that are being log shipped.
(Probably best to test...

All our DBs are relatively small but we do have a couple of servers with highish latency.
I used the following Wait Statistics script, from Paul Randall, to identify the...

Does the SP, or triggers on any of the tables it updates, use the NOLOCK hint or run in READ UNCOMMITED isolation?

If so, get rid of the hint...

>>Is this meant to be a production server? If so, 16gb is exceedingly tiny

I suspect that depends on the system. We have a system with a 12GByte DB...

>> I am considering dropping the database backups processes on the argument that we can always restore the VM and replay the transaction logs.
Are you in a position to...

You have not really provided enough detail.

Assuming the column to be updated is in the same row, try the following outline:

UPDATE Y
SET YourUpdateColumn = 'WhatYouWantToUpdate'