If anyone knows if there is anyway to monitor the progress of the batch commands that have been handled I would love to know, sadly I don’t think this is possible meaning that this approach is not going to be suitable for all situations.In last week’s post I discussed the basics of how automatic updates to statistics occur in SQL Server.If I let SQL Server update statistics automatically, I would need 400,500 rows to change.It’s quite possible that with a table of that size I would want to statistics to update sooner – say after 200,000 rows had changed, or 10% of the table.
When you run the Rebuild Index task in SQL Server 2014, you rebuild all indexes, and when you rebuild an index, its statistic is updated with a fullscan.
There is a reasonably noticeable performance hit when using this approach, even on smallish lists.
So I decided to explore batch processing and found a brief but handy Microsoft page (Batch Updating List Items in Windows Share Point Services 3.0) providing an example of using the SPWeb. An example of which is below: method, this may or not be important depending on what you are doing.
This week I want to talk about scheduled (aka manual) updates, because as you might remember, we really want to control when statistics are updated.
In terms of updating statistics you have multiple options, including: For systems that do not have a full-time DBA, one of the easiest methods for managing statistics is the Update Statistics Task.