It should work I think.  But 0x55555 is an odd number of chars, so the value would actually get set to 0x055555.

Try setting it to 0x555555, that should work more...

I just did a few sample rows, I'm not going to type in all that data.

DROP TABLE IF EXISTS #data;
CREATE TABLE #data ( ENTRY_HOUR tinyint NULL, ENTRY_MINUTE...

You cannot update the value of an identity column.  You would to insert a new row and delete the old row.  That will be way too much overhead.

And, as Thom...

...but I don't think I'll ever be converted to leading commas - I think that's at least partly because I'm an English language pedant and believe that a...

I wouldn't just arbitrarily add a non-clus index without checking existing index usage ("index usage stats") AND reviewing missing indexes ("missing index" stats).

Anyway, my question is to do with square brackets and including schema names. ... My inclination is to leave off as much stuff as possible (he also used to...

How do you typically query the table?  If you normally query by a range of datetime, then changing the clus index makes perfect sense.

First, change the SET @table_name_pattern = '%'...

Something like this.  The key is using aliases (AS ...) for the tables to make the code easier to write and to follow:

SELECT t0.column1, t1.Description, t2.Description, ...
FROM...

Although SQL itself should issue CHECKPOINT commands when being shut down, I've found that explicitly issuing them myself prior to shutdown often allows SQL to restart faster.  So, personally, yes,...

First try getting rid of extraneous parts of the query (reducing the GROUP BY in the outer query):

SELECT [W_SE-MFG].dbo.YearMonthNo(J1.EntryDate) AS Per, SUM(J1.RunTime) AS TReg, MAX(J2.TNQ) AS TNQ
FROM...

Maybe just scan the procedure text for "~TRUNCATE TABLE~" (where ~ is not A-Z0-9$_@).  Then parse out the next word from the text to get the table name.

Again, are you only looking at history for the current instance_id value?

What do you mean "the job history says the job is running."  The jobhistory never shows that, it only show the past history.

Be sure to verify the instance_id. ...

What do you mean "the job history says the job is running."  The jobhistory never shows that, it only show the past history.

Be sure to verify the instance_id.  If it's...

ISNULL/COALESCE is not as clear as explicitly checking for NULL:

SELECT COL1,
CASE WHEN Table1.COL2 = 0 then 'ZERO'
WHEN Table1.COL2 = 1 OR Table1.Col2 IS NULL then 'ONE'
ELSE ''...