Part of out main application has been build by 3rd-party vendor and only recently (less then a year ago) they became SS2K8 certified.

Thanks for your help.

Thanks again.

Few more questions about Stats:

1.How about replacing or creating useful statistics from _WA_Sys_ auto created system stats?

Is it recommended to replace an old auto stat (_WA_Sys_) with a...

Including System Stat (or _WA_Sys_) on heap, right?

Thanks, so by running ...UPDATE STATISTICS ? WITH FULLSCAN, COLUMNS;.. it will also update Columns in heap tables as well, right?

Thank you,

I guess my stopping point is the following:

When you rebuild the index - you rebuild it with 100% sample size, but when you run sp_updatestats a default sampling...

No, I don't update Stats on heap tables.

What I was thinking is to run update statistics on all tables where indexes were NOT rebuld...