When was my table last scaned or updated? | SansSQL

Tuesday, November 18, 2008

When was my table last scaned or updated?

USE DatabaseName
GO

SELECT
         t.name,
         i.last_user_lookup,
         i.last_user_scan,
         i.last_user_seek,
         i.last_user_update
FROM sys.dm_db_index_usage_stats i
         INNER JOIN sys.tables t
         ON i.object_id = t.object_id
WHERE
         database_id = db_id( 'DatabaseName' )

6 comments:

Anonymous said...

Thanks.

kevin calain said...

I appreciate your efforts which you have put into this article. Genuinely it is a useful article to increase our knowledge. Thanks for share an article like this. 8 seater grey rattan corner sofa table online

Huongkvb said...

Liên hệ Aivivu, đặt vé máy bay tham khảo

Vé máy bay đi Mỹ

bay từ california về việt nam mất bao lâu

vé máy bay từ đức về việt nam giá rẻ

vé máy bay giá rẻ từ nga về việt nam

chuyến bay từ anh về việt nam

lịch bay từ pháp về việt nam

các khách sạn cách ly ở hà nội

ve may bay chuyen gia nuoc ngoai

MartenJames said...

In your article, we got knowledgeable ideas. Moreover, get our Mobile Laser Tag Game in San Diego CA services with an active adventure.

jackman10 said...

Rattling nice pattern and great subject material, hardly anything else we need . holiday cash advance from UnitedFinances

TOM said...

Exactly the same thing happened to me so many times that my table was last scanned or updated. But the difference now is that I know how to solve it. Thanks for sharing this with us. I really appreciate that. Now it's time to avail call center jobs in lahore for more information.

Post a Comment

Ads