STRING_AGG is not available in SQL Server 2016.

SQL will separately use each one in order as the previous one gets full.  That is, only one log file per db is ever used at one time.  Unlike data...

I'm not exactly sure what result you want, but if you want only a single result you need to add an ORDER BY to the query.  A TOP (1) without...

Using a sub-SELECT should help, even if the main "table" is actually a view.

SELECT job_op.seq, job_op.description, job_op.part, job_op.router, job_op.router_seq, 
    (SELECT /*TOP (1)*/ job_op_wc.workcenter...

Just off the top of my head, here's on way:

DROP TABLE IF EXISTS #RELATIONSHIP_FLATTENED;
SELECT TOP (0) [CASE], INDIVIDUALID AS ID
INTO #RELATIONSHIP_FLATTENED
FROM RELATIONSHIP
--
CREATE UNIQUE CLUSTERED INDEX [RELATIONSHIP_FLATTENED__CL] 
...

Did you pre-allocate enough log space to handle the entire insert?

I had a load task that took 4+ hours.  I noticed the initial log size was very small.  After I...

What "index maintenance" do you perform on the heap?!

I think a REBUILD should release unused space from a heap.  REBUILD is just:

ALTER TABLE <your_table_name_here> REBUILD;

That load query is fairly straightforward.  I think SQL should be able to write output as it is generated, reducing memory requirements.  Would have to see the query plan to...

I think this will help ( but maybe not?! 🙂 ).  What I sometimes do is rather than using fully dynamic SQL, I use placeholder column names and then rename...

...
(
SELECT 
EPName,
NTUserName,
ParsedUserName,
CAST(FileSize AS decimal(35,2)) AS FileSize, --<<--
SUBSTRING (NTUserName,0,CHARINDEX('\',NTUserName)) AS Domain,
...

SELECT DISTINCT GRPID, PLNCD, XPLNE, EXTNO, EffDate, TermDate

FROM History

WHERE MBRNO IN (SELECT MBRNO FROM dbo.Member_MRN_lkupAllMBRNOs(@strMBRNO))

ORDER BY EffDate ASC

How large (MB/GB) is the "History" table?

How is it clustered?

If it's a (very)...

In SQL Server, you can use DELETE from a table using a JOIN.  Just be sure to alias the table you're deleting from and DELETE from the alias, not the...

Sound like this to me?:

;WITH cte_pat_ordered_by_fac AS (
    SELECT *, ROW_NUMBER() OVER(PARTITION BY p.patient_id ORDER BY p.facility_id) AS row_num
    FROM patient...

--First, I'd strongly urge you to separate the binary data from the main table, which you can do using sp_tableoption.

--Page-compressing the main table will save considerable space, although it may...

Oops, quite true, since I did a combined trigger.

I suggest separating the INSERT and UPDATE triggers.  Then you can use INNER JOIN and not have to test for INSERT vs...