0
(0)

Below query can be used to check when was last update stats run on the database.

use DBNAME
go
select SUBSTRING(@@servername,1,20) 'Server_Name',db_name() 'DB_Name', SUBSTRING(object_name(id),1,30) 'table_name',statmoddate from systabstats where id=object_id('tablename') and indid=0

Sample output:

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.