Why do you not use a much more short and simple

DECLARE @bd DATE = '19801231', @td DATE = '20171231'
SELECT DATEDIFF(YEAR, @bd, @td) - CASE WHEN...

beside the "default" (at least before SQL 2016) Trace Flags 1117 / 1118 (Grow all Files in a FileGroup equally / prevent mixted extends) I'm using:
1222 (allows Deadlock monitoring),...

Nice to know, how to install / configure it, but I still do not know, if and how this will work, when a server crash and has to fail over...

Your code, where you select for definition like '%' +  @ValueToFind + '%' is wrong, since it would return references to MyDB10 and MyDB1_test  and dev_MyDB10 when @ValueToFind is 'MyDB1'.

This is not true.
I just used
DBCC SHRINKFILE (N'mydb_log' , 0, TRUNCATEONLY)
on my 4 GB log file and it is now down to 10 MB (10...

I would have opened the Windows drive management console and changed the drive letter from t: to something else and added t: as additional letter to the d:-drive... (+ maybe...

Would it be possible to install my real instance e.g. at myserver port 9999 and a second instance with empty databases uses the same name at port 1433 that links...

Where do you need RegEx? LIKE is supporting it currently, so the only other point could be something like REPLACE (but I never needed it for REPLACE).

They already added some...

Regarding the OPTION RECOMPILE:

It would help only, when you change your WHERE to something as

WHERE (ISNULL(@ForumName, '') <> '' AND tbo.ForumName LIKE @ForumName + '%')

OR (ISNULL(@SurName,...

A drawback of having the Jobs in the database would be, that - when you restore the database as _test, _dev or whatever, those jobs would be started and this...

@steve-2: What would you do regarding the column order, when you are facing a CREATE OR ALTER <table> statement and the column order differs from the real. Recreating could be...