CTE – With An Insert Statement
Queries with Common table expressions (CTE) are made up of two parts, the CTE part, and the SQL that references the CTE. In preparation for… Read More »CTE – With An Insert Statement
SQL Saturday
Fibonacci Sequence
As part of my CTE research for my SQL Saturday presentation in Redmond in 2 weeks I decided to take on some classic computer science… Read More »Fibonacci Sequence
Generating a Tree Path with a CTE
The following example shows how to create a Tree Path with a Common Table Expression (CTE). First off what is a tree path? For this… Read More »Generating a Tree Path with a CTE
CTE Query Performance
The following question came up when working on my CTE presentation for SQL Saturday. Does a query that JOINs a CTE to itself execute the… Read More »CTE Query Performance
Sessions Submitted for SQL Saturday #120 Orange County CA
After being approved as a speaker at SQL Saturday 114 – Vancouver BC, and SQL Saturday 108 – Redmond WA, I have decided to give… Read More »Sessions Submitted for SQL Saturday #120 Orange County CA
Session Accepted For SQL Saturday 108 in Redmond
I just checked the schedule and one of the sessions that I submitted for SQL Saturday 108 in Redmond WA on February 25th has been accepted. I… Read More »Session Accepted For SQL Saturday 108 in Redmond
2 Sessions Accepted for SQL Saturday 114 in Vancouver
I just checked the schedule and 2 of the sessions that I submitted for SQL Saturday 114 in Vancouver BC on March 17th have been… Read More »2 Sessions Accepted for SQL Saturday 114 in Vancouver
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
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