Updating sequence

Issue I noticed that when I put Windows Updates in the SCCM 2012 Task Sequence (“Deploy” and the “Build and Capture”) some Software Updates weren’t installed.Even after updating the Operating System Images Offline the issue still remained.Benjamin Nevarez is a database professional based in Los Angeles, California who specializes in SQL Server query tuning and optimization.He is the author of three books, “High Performance SQL Server”, “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and has also coauthored other books including “SQL Server 2012 Internals”.4) Reorganizing an index, for example using the ALTER INDEX …REORGANIZE statement, does not update any statistics.

Notice the value of the auto_created column which tells if the statistics were automatically created by the query processor.

1) By default, the UPDATE STATISTICS statement updates both index and column statistics.

Using the COLUMNS option of this statement will update column statistics only.

As mentioned before, if you rebuild all your indexes then all the index statistics will also be updated by scanning all the rows on the table.

Then you just need to update your column statistics by running an UPDATE STATISTICS WITH FULLSCAN, COLUMNS statement.

Leave a Reply