Under compatibility level 110 and higher, the CAST and CONVERT operations on the time and datetime2 data types always have 121 as the default style. If a query relies on the old behavior, use a compatibility level less than 110, or explicitly specify the 0 style in the affected query....
First of all, the black bars – the gen1 and gen4 machines have identical performance in default settings. The Fresh-ET is a bit faster in the compatibility mode but not by much – it mostly equals a CPU swap to a 486DLC (which all of the towers can do, except generations 3 and 4...