#### 顯示每張 Table 的異動次數

SELECT 
    t.name AS TableName,
    ISNULL(ius.user_seeks, 0) + ISNULL(ius.user_scans, 0) + ISNULL(ius.user_lookups, 0) + ISNULL(ius.user_updates, 0) AS TotalActivity
FROM 
    sys.tables t
LEFT JOIN 
    sys.dm_db_index_usage_stats ius 
ON 
    t.object_id = ius.object_id
WHERE 
    ius.database_id = DB_ID()
ORDER BY 
    TotalActivity DESC;