I posted the following SQL Server challenge yesterday:   Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled.   In response, Konstantin Korobkov wanted to know whether the number of data files in tempdb would make a difference.   I did test that scenario and did ...

Here is a SQL Server challenge as I have failed so far:   Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled.   I have seen a lot of chatters, anecdotes, and stories on the impact of trace flag 1118 on reducing tempdb contentions. But I have not seen ...