Jim P. (8/8/2013)
I don't have a good way to test this anymore. But at my last job we would do a data load once a month that consisted of text files that had millions of rows and 30-60 columns to about 60 matching tables.I would purposely grow the tempdb files ahead of time. Then do a shrink afterward. It seemed to work well.
Was that a bad idea?
Over time there has been one test I have done to answer this question and many like it: Did it work? If the answer is yes then it was a good solution. Was it the best solution? Does not matter, it worked and you cleaned up the effects after. Done!
M...
Not all gray hairs are Dinosaurs!