Last week I had the great opportunity to speak at PASS Summit 2015. My presentation was on Common Table Expressions. Here is the sample… Read More »Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs
Today I am presenting on Advanced Common Table Expressions as part of the 24 Hours of PASS conference. It is being webcast so check it… Read More »24 Hours of PASS – Advanced CTE Presenation
Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up… Read More »Using a Common Table Expression Instead of a Derived Table
I just a added a video to YouTube titled “What is a Common Table Expression”. This video covers the extreme basics of what a CTE… Read More »What is a Common Table Expression
Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session: Here is the abstract:… Read More »Introduction to CTEs Slides and Sample Queries
Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First… Read More »What is a Common Table Expression – Video
June was an exciting month for me with Beta 6 of the Database Health Reports releasing at the beginning of the month, and this being… Read More »End of June Summary
The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the… Read More »SQL Server Memory Hog Query
On the next two Saturdays I will be presenting the Unleashing Common Table Expressions presentation at SQL Saturday 172 in Portland Oregon, and SQL Saturday… Read More »Unleashing Common Table Expressions