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,056 reads
Wilfred van Dijk
2015-09-30 (first published: 2015-09-17)
1,544 reads
2015-02-12 (first published: 2010-03-12)
4,899 reads
All OS version info in one function
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,410 reads
move tempdb
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,455 reads
Unique Identifier as Clustered index
This script selects clustered indexes containing only a uniqueidentifier column
2013-10-17 (first published: 2013-10-02)
1,197 reads
usp_addcolumns
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)
938 reads
All SQL Version info in one function
This function returns all the necessary version information in a table.
2012-05-28 (first published: 2012-03-21)
3,129 reads
Convert seconds to a timestring
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,404 reads
Check status of HEAP tables
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,116 reads
Blogs
Social: Respecting Names
By Steve Jones
This is a non-technical post, and my opinion. If you don’t want to read...
Proud to present at this year’s VMworld 2020 conference
By kleegeek
I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...
Daily Coping 7 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How to be an MVP
Comments posted to this topic are about the item How to be an MVP
Does anyone have experience of using securetrading.net as a data src within ADF?
Hi, Does anyone have experience of using securetrading.net as a data source within Azure...
Ask SSC