Getting transaction log space usage statistics for all databases.
Easy way to get the TLOg space Usage details
2019-05-03 (first published: 2015-11-19)
1,355 reads
Easy way to get the TLOg space Usage details
2019-05-03 (first published: 2015-11-19)
1,355 reads
If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.
2019-05-03 (first published: 2016-05-20)
1,452 reads
If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script
2019-05-03 (first published: 2015-07-08)
2,100 reads
The script will be helpful to kill all the user sessions before performing the refresh of the database.
2019-05-03 (first published: 2011-03-29)
2,625 reads
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2019-05-03 (first published: 2015-07-07)
823 reads
2019-05-03 (first published: 2015-09-13)
1,893 reads
Remove backup folders from multiple servers.
2019-05-03 (first published: 2014-12-09)
600 reads
The query will help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.
2019-05-03 (first published: 2012-08-25)
1,222 reads
A script to help you cleanup Files/Folders & Sub-folders.
2019-05-03 (first published: 2015-07-30)
50 reads
2019-05-03 (first published: 2015-05-08)
1,114 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I wrote a PowerQuery that parses a table from a PDF, and I want...
Comments posted to this topic are about the item Attaching an SQL Server database...
Comments posted to this topic are about the item Superseded Indexes
Which of these indexes is superseded by another?
See possible answers