I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

Manual Update statistics on small tables may provide a big impact

This is an interesting thing to know. It seems that automatic update of statistics doesn't work for small tables (up to 500 rows) on SQL server 2000.

More here

Print | posted on Friday, May 12, 2006 10:24 PM | Filed Under [ SQL Server ]

Feedback

Gravatar

# re: Manual Update statistics on small tables may provide a big impact

Posting the same comment from the forums:

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.
5/12/2006 10:52 PM | Tara
Gravatar

# re: Manual Update statistics on small tables may provide a big impact

very informative, it seems doing it automatic doesn't ensure that statistics gets updated

have you tried it on your system yet? did you get the same result? ;)
5/13/2006 4:46 PM | Jen
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET