If a job has only 1 step, then that step started when the job itself started, and you already know how to tell that.

It's long past time that SQL Server should provide a ROWLENGTH function that gives you the physical length of a row(s).  But that's likely just wishful thinking on my part.

Use REBUILD ALL, it will (should) be more efficient.

But pre-grow the log first to the total size you will need for the REBUILD.  It's a very slow process when the...

Of course the lazy way to get an accurate avg row size, if you have the time to let it run, is using:

EXEC sys.dm_db_index_physical_stats

specifying 'DETAILED'.  SQL will then calc the...

I don't know your data.  In the original q, you stated "each day of the week".  So I guessed one week.

If you only need two days, then change the ending...

I've been a SQL Server DBA for 20 years, I've never heard of "magic tables" in SQL Server.  You need to be clearer and more specific about what you're trying...

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]