Newsfeed

Articles

Videos

Post

Blog

Asked Question
Followers: 204
table not used or accesses in last 60 days

table not used or accesses in last 60 days

 

Query

 

SELECT
    t.name AS TableName,
    t.create_date,
    COALESCE(i.last_user_seek, i.last_user_scan, i.last_user_lookup, i.last_user_update) AS LastAccess
FROM
    sys.tables t
LEFT JOIN
    sys.dm_db_index_usage_stats i ON t.object_id = i.object_id
WHERE
 
        i.last_user_seek IS NULL
        AND i.last_user_scan IS NULL
        AND i.last_user_lookup IS NULL
        AND i.last_user_update IS NULL
        OR DATEDIFF(DAY, COALESCE(i.last_user_seek, i.last_user_scan, i.last_user_lookup, i.last_user_update), GETDATE()) > 30 -- 60 days
    AND t.is_ms_shipped = 0 -- Exclude system tables
ORDER BY
    t.create_date;

Share This with your friend by choosing any social account


Upcoming Articles
You may also read following recent Post
Item Image

table not used or accesses in last 60 da...

By Junaid A
130

See Details
Item Image

delete all tables from the database that...

By Junaid A
90

See Details
Item Image

restart sql services using command

By Junaid A
90

See Details
Item Image

The Programming Language Powering MS SQ...

By abrar arshad
300

See Details
Item Image

Search value in database and return tabl...

By Junaid A
263

See Details
Item Image

how to find changes in database

By Junaid A
345

See Details
Item Image

How to caculate Date of Age in ms sql se...

By Junaid A
286

See Details
Item Image

How to download SQL Server 2019

By Junaid A
276

See Details
Item Image

Error handline in sql script

By Junaid A
368

See Details
Item Image

how to check tables and number of rows i...

By Junaid A
382

See Details
Item Image

The backend version is not supported to ...

By Junaid A
764

See Details
Item Image

check which sp has more lines

By Junaid A
381

See Details
Item Image

How to check which database table has mo...

By Junaid A
389

See Details
Item Image

how to check modification in ms sql data...

By Junaid A
289

See Details
Item Image

How To Solve MS SQL SERVER Saving Change...

By Ubaid ur Rehman
1567

See Details
Item Image

procedure to take most viewed products?

By Zaif Ullah
845

See Details
Item Image

procedure to take recent viewed products...

By Zaif Ullah
763

See Details
Item Image

procedure to take related products?

By Zaif Ullah
802

See Details
Item Image

procedure to take product by catagories?

By Zaif Ullah
703

See Details
Item Image

What is pivot Operator ?? Why use Pivot ...

By Rizwan Saqib
835

See Details
Item Image

How Delete all Tables of database Record...

By Rizwan Saqib
925

See Details
Item Image

What is Aliases in SQL?

By Rizwan Saqib
1021

See Details
Item Image

What is Between Operator in SQL ?Why use...

By Rizwan Saqib
684

See Details
Item Image

How and Why use Wild Card Character in S...

By Rizwan Saqib
865

See Details
Item Image

How to Replace Sub string in String

By Rizwan Saqib
934

See Details
Item Image

How Return Location of sub string in Str...

By Rizwan Saqib
759

See Details
Item Image

What is Cross Join ??Why use cross join ...

By Rizwan Saqib
933

See Details
Item Image

How count Difference Between Two date Us...

By Rizwan Saqib
867

See Details
Item Image

Why use Left ()Function in SQL Server

By Rizwan Saqib
921

See Details
Item Image

How to remove Spaces Left and Right side...

By Rizwan Saqib
882

See Details
Item Image

How Improve Execution time of Queries

By Rizwan Saqib
692

See Details
Item Image

5 Tips Speed up SQL Queries

By Rizwan Saqib
867

See Details
Item Image

How delete Duplicate Rows in Table

By Rizwan Saqib
712

See Details
Item Image

How find Max salary of Each Department

By Rizwan Saqib
939

See Details
Item Image

How to get First Row of Each group in a ...

By Rizwan Saqib
931

See Details
Item Image

How convert data types using Convert () ...

By Rizwan Saqib
869

See Details
Item Image

How to cast data types

By Rizwan Saqib
735

See Details
Item Image

Advantages and Workings of DBMS

By Rizwan Saqib
945

See Details
Item Image

What is trigger in database?

By Arsal Ahmed
873

See Details
Item Image

Normalization in SQL Server

By Rizwan Saqib
821

See Details
Item Image

Introduction about keys in SQL Server

By Rizwan Saqib
734

See Details
Item Image

What is SQL Intersect ??

By Rizwan Saqib
805

See Details
Item Image

What is SQL Reporting services (S.S.R.S)...

By Rizwan Saqib
798

See Details
Item Image

What is store Procedure ??

By Rizwan Saqib
817

See Details
Item Image

What is View and how can write view ,upd...

By Rizwan Saqib
667

See Details
Item Image

What is common Table Expression ?Why use...

By Rizwan Saqib
819

See Details
Item Image

What is trigger and Types of trigges

By Rizwan Saqib
962

See Details
Item Image

Union and Union all In SQL Server

By Rizwan Saqib
926

See Details
Item Image

Microsoft SQL Server Joins

By Rizwan Saqib
780

See Details
Item Image

Types Of database

By Rizwan Saqib
903

See Details
Item Image

How to use cursor in sql server and upda...

By Adil Shahbaz
903

See Details
Item Image

History Of DataBase

By Rizwan Saqib
966

See Details
Copyright Future Minutes © 2015- 2024 All Rights Reserved.   Terms of Service  |   Privacy Policy |  Contact US|  Pages|  Whats new?
Update on: Dec 20 2023 05:10 PM
Invite Colleagues

Enter an email address to invite a colleague or co-author to join you on socimo. They will receive an email and, in some cases, up to two reminders.

Send Message
Login
Login Required
Please login if you registered For this Action.
Login
Login
Login Required
Please login if you registered For this Action.
Login