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
11

See Details
Item Image

delete all tables from the database that...

By Junaid A
56

See Details
Item Image

restart sql services using command

By Junaid A
60

See Details
Item Image

The Programming Language Powering MS SQ...

By abrar arshad
267

See Details
Item Image

Search value in database and return tabl...

By Junaid A
226

See Details
Item Image

how to find changes in database

By Junaid A
298

See Details
Item Image

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

By Junaid A
251

See Details
Item Image

How to download SQL Server 2019

By Junaid A
242

See Details
Item Image

Error handline in sql script

By Junaid A
339

See Details
Item Image

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

By Junaid A
336

See Details
Item Image

The backend version is not supported to ...

By Junaid A
684

See Details
Item Image

check which sp has more lines

By Junaid A
338

See Details
Item Image

How to check which database table has mo...

By Junaid A
345

See Details
Item Image

how to check modification in ms sql data...

By Junaid A
253

See Details
Item Image

How To Solve MS SQL SERVER Saving Change...

By Ubaid ur Rehman
1537

See Details
Item Image

procedure to take most viewed products?

By Zaif Ullah
814

See Details
Item Image

procedure to take recent viewed products...

By Zaif Ullah
733

See Details
Item Image

procedure to take related products?

By Zaif Ullah
773

See Details
Item Image

procedure to take product by catagories?

By Zaif Ullah
668

See Details
Item Image

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

By Rizwan Saqib
794

See Details
Item Image

How Delete all Tables of database Record...

By Rizwan Saqib
885

See Details
Item Image

What is Aliases in SQL?

By Rizwan Saqib
986

See Details
Item Image

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

By Rizwan Saqib
641

See Details
Item Image

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

By Rizwan Saqib
831

See Details
Item Image

How to Replace Sub string in String

By Rizwan Saqib
888

See Details
Item Image

How Return Location of sub string in Str...

By Rizwan Saqib
714

See Details
Item Image

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

By Rizwan Saqib
881

See Details
Item Image

How count Difference Between Two date Us...

By Rizwan Saqib
828

See Details
Item Image

Why use Left ()Function in SQL Server

By Rizwan Saqib
879

See Details
Item Image

How to remove Spaces Left and Right side...

By Rizwan Saqib
835

See Details
Item Image

How Improve Execution time of Queries

By Rizwan Saqib
654

See Details
Item Image

5 Tips Speed up SQL Queries

By Rizwan Saqib
831

See Details
Item Image

How delete Duplicate Rows in Table

By Rizwan Saqib
666

See Details
Item Image

How find Max salary of Each Department

By Rizwan Saqib
895

See Details
Item Image

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

By Rizwan Saqib
882

See Details
Item Image

How convert data types using Convert () ...

By Rizwan Saqib
833

See Details
Item Image

How to cast data types

By Rizwan Saqib
690

See Details
Item Image

Advantages and Workings of DBMS

By Rizwan Saqib
899

See Details
Item Image

What is trigger in database?

By Arsal Ahmed
823

See Details
Item Image

Normalization in SQL Server

By Rizwan Saqib
789

See Details
Item Image

Introduction about keys in SQL Server

By Rizwan Saqib
702

See Details
Item Image

What is SQL Intersect ??

By Rizwan Saqib
777

See Details
Item Image

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

By Rizwan Saqib
770

See Details
Item Image

What is store Procedure ??

By Rizwan Saqib
787

See Details
Item Image

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

By Rizwan Saqib
634

See Details
Item Image

What is common Table Expression ?Why use...

By Rizwan Saqib
793

See Details
Item Image

What is trigger and Types of trigges

By Rizwan Saqib
917

See Details
Item Image

Union and Union all In SQL Server

By Rizwan Saqib
893

See Details
Item Image

Microsoft SQL Server Joins

By Rizwan Saqib
730

See Details
Item Image

Types Of database

By Rizwan Saqib
868

See Details
Item Image

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

By Adil Shahbaz
861

See Details
Item Image

History Of DataBase

By Rizwan Saqib
917

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