SQL Job History
[Thursday, January 05, 2012] Manually retrieve the history for a job in SQL Server.
Check for existence of temp table
[Friday, September 23, 2011] MSSQL syntax for checking if a temporary table exists.
Merge - Conditionally Insert, Update, or Delete
[Tuesday, February 15, 2011] Conditionally Insert, Update, or Delete in one SQL statement and even output the results.
Copy Table
[Tuesday, December 07, 2010] A simple way to copy tables in SQL.
Deleting Duplicates
[Tuesday, October 26, 2010] An example of how to easily delete duplicates from a table in MS SQL.
Deactivate Autorecovery
[Friday, October 01, 2010] The autorecovery feature in SQL Management Studio was driving me crazy so I found a way to turn it off.
MS SQL "Stuff" Keyword
[Wednesday, September 22, 2010] The "Stuff" keyword in MS SQL lets you stick multiple subquery results into a single string. Nice.
MS SQL Cursor
[Friday, August 13, 2010] Here's an example of how to create a simple T-SQL cursor to loop through data in mssql.
MS SQL Row Count
[Thursday, August 12, 2010] A quick way to count the rows in every table in a mssql database.
