Report overlapping jobs
This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.
2016-07-29 (first published: 2014-06-21)
2,593 reads
This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.
2016-07-29 (first published: 2014-06-21)
2,593 reads
2015-09-30 (first published: 2015-09-17)
1,742 reads
2015-02-12 (first published: 2010-03-12)
4,923 reads
Always wanted to know the OS details? This function tells you everything (MSSQL 2008R2 and newer version only)
2014-12-29 (first published: 2014-12-06)
1,500 reads
For maximum performance, tempdb should be placed on a seperate disk. This script does all the work for you, except the restart!
2014-10-13 (first published: 2014-09-09)
1,478 reads
This script selects clustered indexes containing only a uniqueidentifier column
2013-10-17 (first published: 2013-10-02)
1,208 reads
This is a stored procedure to add a columns to multiple tables, if column doesn't exist
2013-07-09 (first published: 2008-05-27)
948 reads
This function returns all the necessary version information in a table.
2012-05-28 (first published: 2012-03-21)
3,140 reads
This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'
2010-05-05 (first published: 2010-04-28)
1,408 reads
This SP reports the status of your heap tables. It gives you an overview of fragmentation, ghost record counts and forwarded record counts. Another reason to create a clustered index!
2010-04-09 (first published: 2010-03-09)
2,144 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
If you run this code it creates a 2 row cursor loop. Within the...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers