any idea, if (and if yes then how) small datatypes as TINYINT (= 1 byte) could be compressed in columnstored indexes?

Its clear, that I will save space...

You should use an INLINE TABLE VALUE fuction instead of a scalar function - this would save a lot of time when you import many datasets

CREATE...

Short remark: a FILLFACTOR = 90 on a Identity Column (= auto increment) in a read-only-table (at least no space-growing varchars) makes no sense and wastes 10 % space. Even...

oh, thanks (I usually use only the deep links in the newsletters and visit the SSC start page only very seldom ...

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...