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:

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.

Horace A. Hoover said...

Without more context or information about what table you are referring to, it is impossible to determine when it was last scanned or updated. If you are referring to a digital or electronic table, you may be able to find the date of the last update or scan in the device's settings or system information. Now you can follow Corporate magician for the best things about magic. If you are referring to a physical table, such as a piece of furniture, it is unlikely that it has been scanned or updated recently.

Post a Comment

Ads