http://www.sqlhacks.com/Administration/Row-Count-Inaccurate
If nothing is returned then the usage/indexes statistics are up-to-date.
Line 3: dbcc updateusage (0) updates the current database.
Line 3: with count_rows means that the row count column is also updated.
You need to have admin privileges to the database.
DBCC updateusage (0) WITH count_rows;
go
go
'SQL Server 2008' 카테고리의 다른 글
server collation과 database collation을 한번에 바꾸기 (0) | 2010.11.01 |
---|---|
Optimising Server-Side Paging - Part I (1) | 2010.04.26 |
T-SQL Debugger is back in SQL Server 2008 ... debugging now made easy (0) | 2010.04.08 |
SQL2008의 새로운 기능 - TF-610 (최소 로그) (0) | 2010.01.20 |
SQL2008의 새로운 기능 - 필터링된 인덱스 (0) | 2010.01.13 |