I have a trigger that is running really slow. It takes about 16 seconds to update the linked server table.
I need to update the linked table as soon as the table on the local server is updated. How can I speed this up?
Create Trigger Consent_Date
SET XACT_ABORT ON
SET CONSENTDATE = tblpatient.dtmEligExpires
FROM tblpatient JOIN
BCSQL.dentrix.dbo.DDB_PAT_BASE ON chart = tblpatient.strPatientid
WHERE chart = '900000' --tblpatient.strPatientid