Find Overlapping Jobs

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 […]

5 (2)

2004-01-02

746 reads

sp_dir - Procedure to list database objects

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

426 reads

Blogs

Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”

By

This blog post relates to where you might be doing scale operations of your...

Bash: “command not found” in IF statement

By

This blog post is about a situation where writing an IF THEN ELSE statement...

The First Data Saturday is Tomorrow

By

Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...

Read the latest Blogs

Forums

Data Privacy Grows in California

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data Privacy Grows in California

Grant user access to view database only

By sql_Reporter

Hi I need to grant a user access to a DB on the server...

Need to strip off the beginning of a field in SELECT statement

By tim8w

I have this table that unfortunately has spaces in the field, which I am...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Amend a Commit

See possible answers