Now The SQL Server tempDB is arguably the most important database in any installed instance.  A poorly configured tempdb will trump all the best efforts for design of good OLTP or datawarehouse systems. The standard recommendation is to have one tempdb database file for each CPU.  It’s also generally recognized that this rule of thumb [...]