Browse by Tags

All Tags » performance » database » updateusage (RSS)
How to get updated page or row count information for the current database?
Published 13 August 7 9:0 AM | SSQA.net
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...
Filed under: , , , ,