Posted by SQL Enthusiast
Article by our editor
Sometimes it is useful to see what is currently running on a SQL server. On SQL Server 2005 and later this is fairly easy to achieve using the Dynamic Management View (DMV) dm_exec_requests.
Comments (4) • Read full article »
It's useful to periodically check if there are any old database files that can be deleted from a SQL Server. Usually database files will be deleted along with the database, however this is not always the case. This script will identify unused files.
Comments (1) • Read full article »
More SQL questions »