Technical Article

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 (3)

You rated this post out of 5. Change rating

2004-01-02

1,098 reads

Technical Article

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

You rated this post out of 5. Change rating

2002-07-19

457 reads

Blogs

Azure Workbooks

By

I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...

SQL Prompt Tips–Using $surroundtext$ in a Snippet

By

A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

SQL Server Quickie #46 – SQL Server on Linux

By

Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...

Read the latest Blogs

Forums

The World of Data Science

By urmila880

Comments posted to this topic are about the item The World of Data Science

PowerQuery in SSIS... is it only in 2023?

By pietlinden

First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...

Slicing status based on conditions

By MrRobot

Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers