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
72

See Details
Item Image

delete all tables from the database that...

By Junaid A
70

See Details
Item Image

restart sql services using command

By Junaid A
75

See Details
Item Image

The Programming Language Powering MS SQ...

By abrar arshad
281

See Details
Item Image

Search value in database and return tabl...

By Junaid A
246

See Details
Item Image

how to find changes in database

By Junaid A
318

See Details
Item Image

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

By Junaid A
264

See Details
Item Image

How to download SQL Server 2019

By Junaid A
256

See Details
Item Image

Error handline in sql script

By Junaid A
352

See Details
Item Image

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

By Junaid A
353

See Details
Item Image

The backend version is not supported to ...

By Junaid A
716

See Details
Item Image

check which sp has more lines

By Junaid A
355

See Details
Item Image

How to check which database table has mo...

By Junaid A
362

See Details
Item Image

how to check modification in ms sql data...

By Junaid A
268

See Details
Item Image

How To Solve MS SQL SERVER Saving Change...

By Ubaid ur Rehman
1550

See Details
Item Image

procedure to take most viewed products?

By Zaif Ullah
828

See Details
Item Image

procedure to take recent viewed products...

By Zaif Ullah
744

See Details
Item Image

procedure to take related products?

By Zaif Ullah
786

See Details
Item Image

procedure to take product by catagories?

By Zaif Ullah
685

See Details
Item Image

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

By Rizwan Saqib
810

See Details
Item Image

How Delete all Tables of database Record...

By Rizwan Saqib
903

See Details
Item Image

What is Aliases in SQL?

By Rizwan Saqib
1000

See Details
Item Image

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

By Rizwan Saqib
661

See Details
Item Image

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

By Rizwan Saqib
846

See Details
Item Image

How to Replace Sub string in String

By Rizwan Saqib
904

See Details
Item Image

How Return Location of sub string in Str...

By Rizwan Saqib
731

See Details
Item Image

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

By Rizwan Saqib
900

See Details
Item Image

How count Difference Between Two date Us...

By Rizwan Saqib
841

See Details
Item Image

Why use Left ()Function in SQL Server

By Rizwan Saqib
892

See Details
Item Image

How to remove Spaces Left and Right side...

By Rizwan Saqib
854

See Details
Item Image

How Improve Execution time of Queries

By Rizwan Saqib
667

See Details
Item Image

5 Tips Speed up SQL Queries

By Rizwan Saqib
844

See Details
Item Image

How delete Duplicate Rows in Table

By Rizwan Saqib
684

See Details
Item Image

How find Max salary of Each Department

By Rizwan Saqib
915

See Details
Item Image

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

By Rizwan Saqib
899

See Details
Item Image

How convert data types using Convert () ...

By Rizwan Saqib
846

See Details
Item Image

How to cast data types

By Rizwan Saqib
708

See Details
Item Image

Advantages and Workings of DBMS

By Rizwan Saqib
919

See Details
Item Image

What is trigger in database?

By Arsal Ahmed
842

See Details
Item Image

Normalization in SQL Server

By Rizwan Saqib
801

See Details
Item Image

Introduction about keys in SQL Server

By Rizwan Saqib
716

See Details
Item Image

What is SQL Intersect ??

By Rizwan Saqib
791

See Details
Item Image

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

By Rizwan Saqib
784

See Details
Item Image

What is store Procedure ??

By Rizwan Saqib
797

See Details
Item Image

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

By Rizwan Saqib
645

See Details
Item Image

What is common Table Expression ?Why use...

By Rizwan Saqib
806

See Details
Item Image

What is trigger and Types of trigges

By Rizwan Saqib
933

See Details
Item Image

Union and Union all In SQL Server

By Rizwan Saqib
905

See Details
Item Image

Microsoft SQL Server Joins

By Rizwan Saqib
746

See Details
Item Image

Types Of database

By Rizwan Saqib
883

See Details
Item Image

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

By Adil Shahbaz
876

See Details
Item Image

History Of DataBase

By Rizwan Saqib
938

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