Presenting at SQL Saturday #110

On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...

Removing Identical Duplicate Rows

Deleting duplicate rows out of a table can be tricky.  A brute force way to do this is with a...

SQL Server 2008/2008 R2 Diagnostic Queries for March 2012

Since it is nearly March, I will go ahead and jump the gun by a few days and post an...

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