I'm anticipating this to be my last request for information on this topic but for the life of me I can't seem to see why this isn't working correctly. Rather, there's a HUGE lag when running this ...

The TOP expression doesn't affect statements that might run because of a trigger. The inserted and deleted tables in the triggers return only the rows that are truly affected by the INSERT, UPDATE, ...

SQL Server 2019 (15.x) builds on previous releases to grow SQL Server as a platform that gives you choices of development languages, data types, on-premises or cloud environments, and operating ...