Monthly Archives: November 2011

Recursive CTE’s

As part of my planning for the SQL Saturday Presentation in Vancouver I am creating an hour long presentation on Common Table Expressions. The easiest way to do a recursive query in SQL server is to use a recursive CTE

Posted in CTE, SQL Saturday, TSQL Tagged with: , , , , ,

Another Session Submitted for SQL Saturday

I just submitted a second abstract for SQL Saturday titled Unleashing Common Table Expressions in SQL Server. This is for the SQL Saturday Redmond and SQL Saturday Vancouver BC sessions. I am hoping to get three sessions accepted for Vancouver.

Posted in Classes, CTE, SQL Saturday

Free – Duplicate Indexes Report – Updated

After creating and deploying the duplicate indexes report earlier today I discovered that although the report did exactly what it says, it didn’t do what I needed. The earlier  duplicate indexes report only found indexes that were an exact match on the

Posted in Server Health, SQL Saturday Tagged with: , ,

Free – New Duplicate Indexes Report added

After yesterdays Long Running Queries Report, I have decided to add one more SQL Server Health report. A duplicate indexes report has been added to the Server Health reports. With this report you can track down time waste associated with duplicate indexes. Here

Posted in Server Health, SQL Saturday Tagged with: ,

Free – Long Running Queries Report Created

A long running queries report has been added to the Server Health reports. With this report you can track down time consuming queries that may be causing excessive load on your server. Here is a sample of the new free

Posted in Server Health Tagged with:

Abstracts submitted to SQL Saturday

I just submitted abstracts to SQL Saturday  #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of the two.  Who knows if my session will get accepted, but I am giving it

Posted in Server Health, SQL Saturday Tagged with: , , , , ,

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: