Have you ever wondered what is the optimal configuration for your tempdb database within SQL Server?
There is often significant debate surrounding this subject and so Paul S. Randal, discusses using multiple files for a user DB on a multi-core box in an effort to set the record straight.
I have been doing some very extensive digging into the workings of the tempdb database of late and will be posting more on subject soon.
