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,353 reads
Easy way to get the TLOg space Usage details
2019-05-03 (first published: 2015-11-19)
1,353 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,444 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,097 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,622 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)
822 reads
2019-05-03 (first published: 2015-09-13)
1,892 reads
Remove backup folders from multiple servers.
2019-05-03 (first published: 2014-12-09)
598 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,221 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
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers