title: TempDB one physical datafiles per CPU core in SQL Server 2000
body: <p>I know it is recommended for SQL 2005 onward but does it also apply on SQL Server 2000?
  Any link for reference will also be appreciated.</p>