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,225 reads
Wilfred van Dijk
2015-09-30 (first published: 2015-09-17)
1,621 reads
2015-02-12 (first published: 2010-03-12)
4,905 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,439 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,465 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,202 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)
945 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,134 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,407 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,125 reads
Blogs
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to...
Inspector V2.6 now available
As always the code can be found here in our github repoWe updated our...
Data Mesh: Centralized ownership vs decentralized ownership
By James-Serra
I have done a ton of research lately on Data Mesh (see the excellent...
Forums
Do You Have ALL the YAML?
Comments posted to this topic are about the item Do You Have ALL the...
Why Power Query as an Activity in Azure Data Factory and SSIS?
Comments posted to this topic are about the item Why Power Query as an...
Azure Blob Store Redundancy
Comments posted to this topic are about the item Azure Blob Store Redundancy
Ask SSC