From the course: SQL Server 2016: Administer a Database Infrastructure

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Implement auto update statistics

Implement auto update statistics - SQL Server Tutorial

From the course: SQL Server 2016: Administer a Database Infrastructure

Start my 1-month free trial

Implement auto update statistics

“

- [Narrator] Indexed statistics are automatically created at the time the index is created. After that, they need to be updated to keep pace with changes to the data table. Sequel server can do this on its own if the correct options are enabled. To check on the status of the options we can pull some information out of the sys.databases view. Now there's a lot of columns that this view contains so I only want the name and the columns called is auto create status on and is auto update status on. Let's go ahead and run lines two and three. In the results we can see a listing of all the different databases that exist on my server instance. And we can that is auto create stats on is all listed as one and is auto update stats on are again all listed as one. This means that these two features are enabled for all the databases on my server. If you were to see any zeros then that would mean that the option is disabled for you. You can toggle the options with some simple t sequel commands. We…

Contents