SQL Server Agent Job Steps

To list a SQL Server Agent Job Steps use the T-SQL example below.
This example displays the step id, SQL Server...

A Script A Day - Day 21 - The HAVING Clause

Today’s post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is...

A Script A Day - Day 22 - Database Backup

Today’s script follows on from Day 16’s script which was about database restores.  In a backwards way the script is...

A Script A Day - Day 23 - Find an Object In Job Steps

Today’s script is one which saves me a lot of time on occasion.  On large systems with lets say more...

Another 24 Hours of PASS

Nothing like a 24 hour barrage of SQL Server training for FREE!!! Did I mention it was free?
The PASS Data...

Detect Worst Performing SQL Queries - Part 3

Detect Worst Performing SQL Queries - Part 3

Detect Worst Performing SQL Queries - Part 3

Detect Worst Performing SQL Queries - Part 3

Detect Worst Performing SQL Queries – Part 3

Best way to tune production server is to find out what are the queries executed in a particular duration and...