Monthly Archives: December 2011

Multiple CTE’s in a single Query

Common Table Expressions are a great way to simplify complex derived table queries. If it makes sense to break out one derived table or subquery into a CTE, it can make sense to do multiple. To use multiple CTE’s in

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

Index Statistics Report added to the FREE SQL Server Health Reports

In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. The new Index Statistics Report is the 8th report in the series, intended to give DBA’s and

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

It is sad when Santa Claus wants to break into your bank account.

Normally by blog/website is focused only on SQL Server topics, but this just jumped out at me and I have to share it.   The holiday shopping season is here again, and so are the scammers.  Here is a copy

Posted in Other Tagged with:

Backup Set Report added to FREE Server Health Reports

In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. This report has been replaced with the Backup Report in the Database Health Project. The Backup Set

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

Database Size report added to SQL Health Reports

In preparation for a SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project.   The Database Size Report has been added to the SQL Health Reports.  The Database Size Report  is

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

SQL Server Join Types – inner join, left outer join, right outer join, full outer join, cross join and self join

I submitted another abstract for SQL Saturday titled TSQL Basics – SQL Server Join Types. Focusing on inner join, left outer join, right outer join, full outer join, cross join and self join. This is for the SQL Saturday in

Posted in 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: