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… Read More »Multiple CTE’s in a single Query
Classes
Notes from SQL Server Classes
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… Read More »Index Statistics Report added to the FREE SQL Server Health Reports
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… Read More »Backup Set Report added to FREE Server Health Reports
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… Read More »Database Size report added to SQL Health Reports
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,… Read More »SQL Server Join Types – inner join, left outer join, right outer join, full outer join, cross join and self join
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.
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… Read More »Recursive CTE’s
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… Read More »Another Session Submitted for 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… Read More »Free – Duplicate Indexes Report – Updated
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… Read More »Free – New Duplicate Indexes Report added