Update: I restarted the servers (resource governor still disable on primary node) and memory target and totals now come up accurately and I am not getting semaphore waits. So basically, I...

Open the Flat File Source and Click the check box in the attached picture. Compile and run.

A huge and common mistake I have seen is when a trigger is written from the perspective that only one row is affected.

For example:

Select @someVar = SomeValue

From inserted

If the statement...

I was interested in this article because I thought I would write a reply like "Hey didn't you know SQL already has a function for that?"

Apparently the author already knows...