SQL SERVER – TempDB and Trace Flag 1117 and 1118 – Not Required

(Pinal Dave) Yes, it is true that from SQL Server 2016, Trace Flag 1117 and 1118 are not required. Recently I was hired by a large banking firm to help them with the Comprehensive Database Performance Health Check.

Register to Read