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,647 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,647 reads
2015-09-30 (first published: 2015-09-17)
1,767 reads
2015-02-12 (first published: 2010-03-12)
4,936 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,522 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,488 reads
This script selects clustered indexes containing only a uniqueidentifier column
2013-10-17 (first published: 2013-10-02)
1,213 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)
957 reads
This function returns all the necessary version information in a table.
2012-05-28 (first published: 2012-03-21)
3,148 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,429 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,158 reads
Logging is a necessity in the database world, well, the entire tech world. You...
By Rayis Imayev
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media...
By Steve Jones
It’s been a week since I flew home from London and Redgate to begin...
Discover the top Excel features for accountants that supercharge productivity—from PivotTables and Power Query...
Comments posted to this topic are about the item The Mindset of a Database...
Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers