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:

  1. 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

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

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

    ReplyDelete
  4. 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.

    ReplyDelete
  5. 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.

    ReplyDelete