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,741 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,143 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
I have a column that contains comma separated values. I'm trying to figure out...
Have anyone implemented CDC, and if so, what has been your experience with it?...
I'm getting a error when using the Import and Export wizard to copy tables...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers