That's good information - and I am going to look into it..

Can you answer my questions regarding the following:

1. The original tempdb.mdf was 40 GB, with this script I would resize it down to 10GB and added 3 data files. What's the impact? Putting it another way - I just modified a database, placing content over 4 files. What has SQL done to make sure integrity is ok, content has not been corrupted.

2. After running the script, how do you evaluate tempdb is functioning properly?

Anything on this?