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,194 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

474 reads

Blogs

Microsoft finally adds Tenant Switcher for Fabric / Power BI

By

Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...

Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices

By

Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...

Building Effective Data Governance Framework: Top Areas to Focus On

By

The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...

Read the latest Blogs

Forums

Pull mssql to Postgres

By Bruin

Does anyone have a script\example that would connect to SQL server instance run a...

Fill in missing hours for each VisitID during the day

By NineIron

create table #T ( VisitID varchar(30), ER_Date date, HR int ) insert into #T(VisitID,...

Database copy for report work load

By ashrukpm

Hi Team, I am looking for a an help, Please see my problem below....

Visit the forum

Question of the Day

The Hash Join I

What are the two inputs called to a hash join operation in SQL Server? (choose 2)

See possible answers