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,592 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,592 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
Have you ever wanted to filter a visual by selecting a range of values...
By Steve Jones
I wrote a post recently about pruning branches in git. That’s part of the...
By James Serra
I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...
Hi all, We have a SSIS package that does 2 things in parallel: moves...
We have pretty big tables very sensitive to stats with many updates. Our systems...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers