DBCC UPDATEUSAGE Command On SQL Server

 

DBCC UPDATEUSAGE Detects and corrects errors in Page and row numbers.

Prior to SQL Server 2005, the number of rows of some of the tables and indexes could look negative. If you run the DBCC CHECKDB command it checks this, and if this is the case, it recommends using the DBCC UPDATEUSAGE command.

This control is performed for the Test database with the help of the following command.

This check is can be performed for the TestTable table in the Test database with the help of the following command.

This control can be performed for the IX_column1 index in the TestTable table in the Test database with the help of the following command.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *