What is an "admin" delete? When the delete is done both a sys admin? If so, why not disable and then re-enable the trigger?
DISABLE TRIGGER dbo.YouurTrigger ON dbo.YourTable;

What do you mean by "gain"? If you compress something (in data terms), you "gain" storage space. Is that what you mean?

What have you tried so far? I also don't really understand how you get the expected results from your sample data. Could you explain further?

I suspect the problem is that you have characters that are read right to left, and well as characters read left to right. When you copy those, the positions change,...

We

I've done a simple script, just to double check, and I can't replicate the issue (see below). Tom is right, we need the DDL here really, and some sample data...

Using a function on a column generally makes the query non-SARGable. This means any indexes you have on that table/column cannot be used. If you need to check whether a...

I'f I'm understanding correctly, Brandie, this should do what you want. By default Get-ChildItem won't recurse, and using -file will mean it excludes folders. Thus you can do something like...

You're probably looking at something like this instead now: https://www.amazon.co.uk/MCSA-Server-Database-Development-2-pack/dp/1509303650/ref=la_B001IGQENW_1_2?s=books&ie=UTF8&qid=1530532113&sr=1-2

Those are by the same author as Inside Microsoft® SQL Server® 2008, Itzik Ben-Gan, however are...

Have you looked into Server and database triggers? That'll be a place to start.

Why not just..?

INSERT INTO YourOtherTable (ForeignKey, CurrentDate)
SELECT ID, GETDATE()
FROM Table1
WHERE [Name] = @Name1;

INSERT INTO YourOtherTable (ForeignKey, CurrentDate)
SELECT ID, GETDATE()
FROM Table2
WHERE...