You guys must be suffering from Covid or something.  You guys know better than to banter about with claims of performance without demonstrative code to prove your position. Especially...

Yes, you can drop IDX1; IDX12 can cover all queries that would use IDX1.

Sure, you can do that.  And you should do that.

You could also move those columns (attributes) into the main table, but it's often useful to have a separate 1-1 table...

No, you'd use table DML triggers to handle table modifications (DELETE  and/or INSERT and/or UPDATE).

  IF (
        (
            (ABS(SIGN(@Var1-@VarA)))...

Yep, that is...

I would think that would be possible.

Can you bring that filegroup back online and REMOVE it?  I  think that would clear it up, if that was the issue.

The code given with the /15 and *15 integer math is to figure out the 15-minute time period that contains the current time.  As I write this, it is...

There must be some active transaction (or replication or other task that needs the log records).

What does DBCC OPENTRAN on that db show?

Wouldn't you want just the network?  The recipients are email addresses, not phone numbers afaik.

@recipients = @N,

WHERE 
    D >= DATEADD(MINUTE, DATEDIFF(MINUTE, 0, GETDATE()) / 15 * 15, 0) AND
    D <  DATEADD(MINUTE, DATEDIFF(MINUTE, 0, GETDATE())...

For the ~100K rows in the tmp table, what percent range of the DeliveryTimetableID values in the larger tables do they represent?

That is, if the min/max values of DeliveryTimetableID in...

SELECT B.InsDtTime, A.RunDate, A.AID, A.AValue AS NewValue, B.AValue AS OldValue
FROM #tblTest1 A
CROSS APPLY (
    SELECT TOP (1) *
    FROM #tblTest2 B
...

• This reply was modified 5 years, 1 months ago by ScottPletcher. Reason: Corrected bugs in the query

Hmm, unless your data involves most of the table, I would think SQL could use a MERGE join rather than the HASH join for all those rows.  Would you be...

Everything we do today is affected by punchcards, and then by COBOL. Look at how 00 programming still assumes a procedural model.

Are you surprised that all animals have DNA?...