This script gives you an idea on how long the processing time is for your SQL jobs. It will depend on how many records are being retained on the sysjobhistory table (scripts defaults to the last 30 days--may not find any history at all).One may find it useful when there are so many sql jobs […]
2003-02-06
5,822 reads
This script list all SQL Server Jobs with schedule details. One will not need to go to the enterprise manager and verify each job properties just to get the scheduled frequency for each job.
2003-01-31
1,142 reads
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
The thread for the league in 2025. Players from last year have priority.
Forgot I posted a similar issue back in 2020, String or Binary Truncation Error...
If I have Read replica (in Azure SQL MI), can it be used as...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers