[Script Of Jan. 09] How to update statistics on tables or views in a SQL Server database

image

Jan.

09

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-update-statistics-5d74eb14.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This script is to help update statistics in a SQL Server database.

As some people asked how to update statistics in a SQL Server database, this script will help to do it. If the statistics have changed drastically and you want to update them before query optimizer does, this script will provide you with some support.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery