Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 SS2k auto update stats on small tables

Author  Topic 

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-05-12 : 16:44:46
i know not everyone reads blogs here (shame on you!!)
so i posted this here also because it's good to know.

Link

Go with the flow & have fun! Else fight the flow
Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"]

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-05-12 : 16:50:41
You aren't supposed to rely on the auto update statistics anyway. You are supposed to have it enabled plus also have a job that runs UPDATE STATISTICS. I believe this information can be found at sql-server-performance.com.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -