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
832 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
435 reads
By todd-32417
Join us August 17 (Americas) or August 18 (Asia-Pacific). Register today!
By Steve Jones
I traveled to Pasadena, CA this week to work with a few other Redgaters...
By DataOnWheels
The step-by-step process below walks through connecting to data housed in Azure Blob Storage...
I am trying to get the last day of the year from a date...
Hello: Right now I have two queries as shown below: SELECT D.DocumentID AS [Document...
Comments posted to this topic are about the item Excel Formula to create SQL...
Ask SSC