An Easy Way To Optimize Page Allocation in TempDB »
By Kelly Martinez on Jul 11, 2010 in SQL | 1 Comment
The other day (prompted by a tweet by @buckwoody) I ran the Microsoft Baseline Analyzer on one of my SQL DBs. One of the recommendations it made was that I create multiple data files for tempDB as allocations were slow. I vaguely remember reading about doing this but was still hazy on the details. So [...]
