For the cleanup of unused objects, does someone have a script or knows a DMV to indicate when a view or function was last accessed?
I've found a script, but this only returns the last_execution_time for Stored Procedures.
Select *
from sysobjects S
left join sys.dm_exec_procedure_stats X on X.object_id = S.id
where S.xtype in ('P' ,'X', 'FN', 'V')