|
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
(comments are locked)
|
|
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.
(comments are locked)
|
|
See some of the discussion here : http://ask.sqlservercentral.com/questions/5109
(comments are locked)
|
Your answer
