You can identify unused Tables in the following way:
; with Unused (TableName , RowCount, DateCreated, DateModified)AS (SELECT unusedTable.name AS TableName,PS.row_count AS RowCount,unusedTable.create_date AS DateCreated,unusedTable.modify_date AS DateModifiedFROM sys.all_objects UnusedTableJOIN sys.dm_db_partition_stats PS ON OBJECT_NAME(PS.object_id)=unusedTable.nameWHERE unusedTable.type ='U'AND NOT EXISTS (SELECT OBJECT_IDFROM sys.dm_db_index_usage_statsWHERE OBJECT_ID = unusedTable.object_id ))SELECT TableName , RowCount, DateCreated, DateModifiedFROM UnusedORDER BY RowCount
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
