Script lists all overlapping jobs that ran on selected server within last @Hoursback hours.Basically, idea behind this is to find jobs that are running at the same time, because that might significantly slow down server, especially if you have jobs that are running during business hours. You can do the same by looking into Jobs […]
2004-01-02
642 reads
Lists objects from database. Similar to 'dir' command from DOS 🙂Typical usage sp_dir 't' 'order*', 1 - returns list of all tables whose name start with 'order' plus their columns and data typessp_dir 'p' 'custom*_sp' - returns list of all stored procedures whose name start with 'custom' and end up with '_sp'For list of […]
2002-07-19
419 reads
By James-Serra
I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...
Hello all, i would like to send a html Mail with sql server. But...
Hello all, I really need your help – I want to use the sample...
Hi Forum, I have a table that uses the script below to create fields...
Ask SSC