Auto Update Statistics and Tempdb

Is there any use for "Auto Update Statistics" enabled on TempDB?
Or would it be an hinderance?If you have people who create tables and indexes in tempdb, then insert rows
and use the data. you should probably leave it turned on.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"frankm" <frank@.nxspxm.mallardcentral.com> wrote in message
news:%23Ir7u5JTEHA.1472@.TK2MSFTNGP09.phx.gbl...
> Is there any use for "Auto Update Statistics" enabled on TempDB?
> Or would it be an hinderance?
>|||frankm,
Yep, I agree with Wayne, leave it on.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
frankm wrote:
> Is there any use for "Auto Update Statistics" enabled on TempDB?
> Or would it be an hinderance?
>