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.
| Author |
Topic |
|
SCHEMA
Posting Yak Master
192 Posts |
 Posted - 2009-05-07 : 11:01:37
|
| We have Rebuild indexes job for all databases every weekend. We have AUTO_Update statistics turned on. Question:1) Should we update statistics for all databases every night?There is minimal data changes (like 5 %). Any good knowledge? what you guys doing for production server? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-05-07 : 11:05:10
|
| index rebuild already has full statistics done.note that index defrag doesn't NOT update stats.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
 |
|
|
SCHEMA
Posting Yak Master
192 Posts |
Posted - 2009-05-07 : 11:08:08
|
| I know that but should we update statistics for all databases everyday with sp_updatestats.What does people do in production server? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-05-07 : 11:14:53
|
| that totaly depends on how much insert, delete, update activity you have.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
|
|
|
|
Should we update statistics or not?