Rank: Administration
Medals: Groups: Administrators
Joined: 10/20/2012 Posts: 106 Points: 327 Location: Tbilisi
Thanks: 0 times Was thanked: 0 time(s) in 0 post(s)
|
BB კოდი:SELECT OBJECT_NAME(object_id) AS DatabaseName, last_user_update, database_id, object_id, index_id, user_seeks, user_scans, user_lookups, user_updates, last_user_seek, last_user_scan, last_user_lookup, system_seeks, system_scans, system_lookups, system_updates, last_system_seek, last_system_scan, last_system_lookup, last_system_update FROM sys.dm_db_index_usage_stats WHERE (database_id = DB_ID('<DATABASENAME>')) AND (object_id = OBJECT_ID('<DABLENANE>'))
|
|
Apex ltd. http://www.apex.ge
|