SQL Server can benefit from multiple data files because this can reduce contention on tempdb resources. The general recommendation is to have one data file per logical processor up to eight.

Share This Article Do the sharing thingy 0000 Similar Posts From Tech Category ...