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: , ,

Size of all databases on one SQL Server

Here is a script that I created to get the size of all of the databases on one SQL Server. Generally I stay away from temp tables, especially global temp tables, but I didn’t see a good way to do

Posted in TSQL Tagged with: , ,

Determining free disk space with TSQL

Working on a new report for the SQL Server Health reports, I needed to display the amount of free disk space on a SQL Server. EXEC MASTER..Xp_fixeddrives; Which was useful if I just wanted to look, but I needed to use

Posted in DBA, TSQL Tagged with: , , , , , , ,

CPU Utilization Report added to SQL Server Health Reports

The CPU utilization report has been added into the SQl Server Health Reports. Here is a preview of the report.

Posted in Classes, Server Health, SQL Saturday

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

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