CTE Hierarchy compared to the alternative
After my CTE presentation at SQL Saturday 108 in Redmond, I was asked many questions, and received several great suggestions from people. Based on that… Read More »CTE Hierarchy compared to the alternative
February 2012
A Great Day at SQL Saturday 108 in Redmond.
WOW, what a great day at SQL Saturday 108 in Redmond. I started out with a keynote presentation from Buck Woody. Then I delivered my… Read More »A Great Day at SQL Saturday 108 in Redmond.
KeePass – for security and time savings
After a recent tour at a couple companies who are using the LEAN process, I have decided to take on LEAN in my everyday work.… Read More »KeePass – for security and time savings
KeePass – to improve your process
Before proceeding with the article, please take this quick password safety test. Password Safety Test – Score one point for every YES answer.: Do you… Read More »KeePass – to improve your process
Calculating Factorials with a Recursive CTE
What is a Factorial: The product of an integer and all the integers below it; e.g., factorial four (4!) is equal to 24. The factorial of a… Read More »Calculating Factorials with a Recursive CTE
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
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