I've tried it on 2016SP1CU3, 2016SP1CU5, 2017CU2, all with default collation of Latin1_General_CI_AI, and also only got the single row...

I'm just going to leave this here...  https://www.brentozar.com/archive/2015/03/ten-ways-tell-sql-server-clown-car/

Seriously, though - that server needs more memory.  Especially if you have non-SQL Serer processes running on it.  Having...

Yes, it should be possible, using the date comparisons for the start and end dates of the overall job (determined from Step 0 in the job history table) and looking...

There are two interpretations for "Julian Date"

The one you've got is the corrupted version - being the year followed by the day number within the year.

The...

Duplicate of https://www.sqlservercentral.com/Forums/1909139/Trigger-to-notify-when-mssql-job-is-disabled

What's New in SQL Server 2017 - https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2017
What's New in SQL Server 2016 - https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2016
What's New in SQL Server 2014 - https://msdn.microsoft.com/library/bb500435(v=sql.120).aspx
What's New in SQL Server 2012...

The version I heard is "..professionals practise until they *can't* get it wrong"...

I think that, at five years old, my laptop doesn't so much need upgrading as replacing.

The problem is that it was a beast of a thing when I...

There is a UserVoice feature request for this functionality - go vote it up!

sp_msforeachDB doesn't work quite the way you think.

What you need to do is to alter your @command string to either change database specifically, or to change the @command...