I discovered that "auto create statistics" and "auto update statistics" are enabled on Tempdb. Since no large tables / indexes are created in Tempdb (in my environment) I was wondering if statistics maintenance was necessary. It saves some resources...
Note: MSSQL 2005 x64, SP3, Hf7
asked Mar 31, 2010 at 06:16 AM in Default
You and your people aren't the only ones that use TempDB. It is the lifeblood of SQL Server right along with memory. I wouldn't touch any of the factory default settings on TempDB except for Growth settings.
answered Apr 10, 2010 at 03:45 PM