• Just chiming in to reiterate what t.franz has already mentioned.  -T1117 and -T1118  so that tempdb behaves well with multiple data files prior to 2016.  Also a big thank you to K. Taranov for the original listing of trace flags. Great list.
    Thanks
    Jeff Bennett