Not directly.  But sysjobhistory has the time each step started and the duration of the step.  Of course that means that the row for a step cannot be written to...

> 1024 * Reserved_Page_Count * 8 / Row_Count.  My question  here is, why the 1024? <<

So that the final calc is in bytes, not kb.  That makes sense, since hopefully...

WHERE  tdate >= '12-28-2020 17:00' and tdate < DATEADD(DAY, 7, '12-28-2020 05:00') and
     (DATEPART(HOUR, tdate) BETWEEN 17 AND 23 or DATEPART(HOUR, tdate)...

It shouldn't take anything remotely close to 12 hours to rebuild indexes on tables that size with that much RAM available.

Unless maybe the table's incredibly wide.  What is the average...

First Possibility:

Restore the last backup of the db to a different db name, then copy the table employee table from the restored db over the employee table in the original...

Two decimal places is the default when coverting from money to char.  From MS docs, "CAST and CONVERT":

"

money

0 (default)

No commas every three digits to the left of the decimal point, and...

Was anything resolved on the earlier q where you asked about this?

You're very welcome.  Thanks for the feedback.

,SUM(CASE WHEN ServCode = 'MST' THEN 1 WHEN ServCode = 'S&M' THEN 1 WHEN RepairCodes.[Service] = 'Y' THEN 1 ELSE 0 END) AS [SERVICE]

In SQL Server, there is a way to assign a usable column alias, using CROSS APPLY:

SELECT TOP (1000) ST100
FROM CONSUL AS CD
LEFT JOIN table2 AS [Sx] ON...

Double any existing single quotes in the data:

... + REPLACE(data, '''', '''''') /*make every ' in the data become '' */ + ...

I've never seen an UPDATE pattern that bizarre in over 30 years in IT.  From 6 to 16,000,000?  I can't even imagine the business case that would cause...

"Standard Procedure...

I still prefer my single int as a metakey method.  16 bytes is a lot of overhead for a linking key.  I don't see an advantage to it. ...

I still prefer my single int as a metakey method.  16 bytes is a lot of overhead for a linking key.  I don't see an advantage to it.  And the...