How to find unused Table and Recently executed query in Sql Server

How to find unused tables in SQL Server

Here's a query which can give you a clear idea about the unused tables in your database.

select 
t.name as 'table', 
sum(i.user_seeks + i.user_scans + i.user_lookups)as 'total accesses',sum(i.user_seeks) as 'seeks',sum(i.user_scans) as 'scans',sum(i.user_lookups) as 'lookups'from 
sys.dm_db_index_usage_stats i right outer join 
sys.tables t on (t.object_id = i.object_id)group by 
i.object_id, 
t.name
order by [total accesses] desc

How to Find Recently Executed Queries

Here is the query which we used to find out the recently executed queries along with the date and time at which they were executed.

SELECTDMExQryStats.last_execution_time AS [Executed At],DMExSQLTxt.text AS [Query]FROMsys.dm_exec_query_stats AS DMExQryStats
CROSS APPLY
sys.dm_exec_sql_text(DMExQryStats.sql_handle) AS DMExSQLTxt
ORDER BYDMExQryStats.last_execution_time DESC

Hope this will be useful to you also.