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,074 reads
Wilfred van Dijk
2015-09-30 (first published: 2015-09-17)
1,563 reads
2015-02-12 (first published: 2010-03-12)
4,900 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,417 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,458 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,199 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)
940 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
Quick Start to Using Influxdb on Macos
By Sheldon Hull
Intro OSS 2.0 is a release candidate at this time, so this may change once...
Error: 8623 - The query processor ran out of internal resources and could not produce a query plan
Unfortunately a common error in many of our client environments is this: -- Error: 8623, Severity:...
Goal Progress– October 2020
By Steve Jones
This is my report, which continues on from the Aug report. After that report,...
Forums
How to minimize the SQL Server log growth
In SQL Server 2014, I go to my database properties and tempdb's database properties...
What is Possible?
Comments posted to this topic are about the item What is Possible?
I cannot add a replica because of difference between instances
Hi There, Let me start with to say I am not a SQL administrator,...
Ask SSC