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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-11-10 : 19:02:44
|
| Hello,I am very very frustrated. We run bunch of cobol jobs for payroll on monday and tuesday and monday one the most intensive is a problem child since it takes for ever!! I have to ask user to cancel it then I run update stats for those affected tables and then the job runs fine. I heard in one of the conference that MSSQL DB 2K's Auto Update Stats feature should be switched off since it sometimes updates at the wrong time and not necessarily the best way and it affects the stats that are built on indexes only.Is this true? Also, If I just do the this command, does it update stats 100% for all stats on key or non-key cols?--Update Stats Pay_Check_Tbl--Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-10 : 19:38:39
|
| That will update all stats on the table.Does the app use stored procs - if not consider converting it to use them and then you can optimise the SPs - maybe giving optimiser hints so that statistics are unneccessary.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-11-11 : 16:40:58
|
| Unfortunately I cannot touch any payroll process that PSoft provides even if it is broken. What I am trying to make sure is that I have the best possible optimization setup on the database.Is it true about Auto Stats ON being an issue?Thanks,Sarat**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-11-18 : 18:34:39
|
| So, I heard in one of the conference that MSSQL DB 2K's Auto Update Stats feature should be switched off since it sometimes updates at the wrong time and not necessarily the best way and it affects the stats that are built on indexes only.Is this true? **To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
|
|
|
Update stats acting weird