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 ...

Creates a relational index on a table or view. Also called a rowstore index because it is either a clustered or nonclustered B-tree index. You can create a rowstore index before there is data in the ...

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, ...