Here is a simple query I run to see when a database was last accessed.

SELECT TOP 10000 s.[database_id]

,d.name

,d.create_date

,s.[user_seeks]

,s.[user_scans]

,s.[user_lookups]

,s.[user_updates]

,s.[last_user_seek]

,s.[last_user_scan]

,s.[last_user_lookup]

,s.[last_user_update]

FROM [master].[sys].[dm_db_index_usage_stats] as s right outer join sys.databases d on s.database_id = d.database_id

where...

Couldn't help but notice the succession of articles the past two days.  Yesterday, Steve wrote about the "Vast Expansions of Hardware" which took me down memory lane, and now you...

Once again, Steve, you make a great observation, "this is a partnership."  Reaching way back to Greenbelt, Blackbelt and Design for Six-Sigma days, what was stressed at the forefront was...

Thank you for your feedback Thomas, but to clarify, my script was based on the example used in the original article.  At that time, the originating author showed "4000" to...

This is a very relevant article and far too often code is written in such a way that Log space is consumed as a result of attempting to delete too...

Great job on the Triathlon!!!  Been doing them for over 25 years (various distances).  Key Largo, FL is this weekend (8-18-24).

A very crucial point and sometimes a lacking in management...

I have a slightly used copy of Foxpro I can let you have at low price......

There are rippling effects to staying on old software.  It takes old (not safe) OS...

I totally concur.  Back in the late 90's and early 2000s Hoshin Principles; Greenbelt and Blackbelt training; Design-for-Six-Sigma, all stressed the importance of the "voice of the customer" and "no-value...

I would definitely attempt to shrink Tempdb.  I would shrink each file individually as much as possible.  Also, you need to see what drive your tempdb files are stored on...

Here are some basic things I would check.  TempDB files - both data and logs.  When you reboot a server these get reset.  Do you have enought space for these...