SQL Server Performance

How to get updated page or row count information for the current database?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 13, 2007.

  1. Anonymous New Member

    DBCC UPDATEUSAGE (0); GO Best practice to use DBCC UPDATEUSAGE i ntermittently and must if you have upgraded the database from SQL 2000 to 2005. The usual working fashion of this DBCC statement is to correct the rows, used pages, reserved pages, leaf pages, and data page counts for each partition in a table or index. If there are no inaccuracies in the system tables, DBCC UPDATEUSAGE returns no data. If inaccuracies are found and corrected and you have not used WITH NO_INFOMSGS, DBCC UPDATEUSAGE...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/08/13/how-to-get-updated-page-or-row-count-information-for-the-current-database.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1389" width="1" height="1">

Share This Page