Day 2 of Common Table Expression Month (June) at SteveStedman.com, today I will cover creating your very first CTE. Keep in mind that this may look a bit weird or strange at first, the syntax is different from anything you may have seen with SQL Server before, and there are some parts that are very similar. First lets take a …
Writing Your First Common Table Expression with SQL Server Read more »
As I have presented my Common Table Expressions presentation many times, and as part of writing the Common Table Expressions Book I have created some sample database scripts to use. Once you load up the script into SSMS and refresh the databases tree item, you will see a new database called cte_demo that includes 2 tables. dbo.Departments The first table is called …
This month is going to be Common Table Expressions Month at SteveStedman.com. My goal is to post one valuable post on a Common Table Expressions topic each day for the entire month. What is a Common Table Expression A Common Table Expression (know as CTE) is a type of in memory result set, similar to a view or a …
Common Table Expression (CTE) Month at SteveStedman.com Read more »
I used to be able to do the Common Table Expression in a single 1 hour session, but after writing the book on Common Table Expressions, I discovered that I just can’t fit it into an hour with the detail that Common Table Expressions deserve. I would rather go into depth so that everyone can master CTEs rather than just breezing …
My Common Table Expressions book is now available at Amazon.com as both the normal printed book, and the Kindle version. Just in time for SQL Saturday Redmond tomorrow.
My Common Table Expression presentation was accepted for SQL Saturday 212 in Redmond WA. This is the session that I am the most familiar with, and that I have presented the most times. I think this will be the 8th time I have presented this session, and after every previous presentation it has been improved. Over the last several months …
Common Table Expression accepted for SQL Saturday 212 in Redmond WA Read more »
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 article could just be “SQL Server Bug Report” depending on how you look at it. When presenting unleashing Common Table Expressions at SQL Saturday a while back, I was asked a couple of great questions …
Last month I posted another CTE blog entry Using a CTE to Split a String Into Rows with Line Numbers. Since then I have used it but, but realized that what I really needed was a diff tool to compare two strings similar to the command line diff tool. First we take a look the SplitWithLineNumber from the previous article. This …
Last year while working on my CTE presentation for a SQL Saturday I added a blog post called “Using a CTE to Split a String Into Rows“, and since that posting I have used it many times. But as things go in development, eventually there is a need to do something more. Doing some complex string building to create files …
Using a CTE to Split a String Into Rows with Line Numbers Read more »
I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run Faster” Switch The NO_LOCK hint is often believed to be the “Run Faster” switch, but in reality can cause some very inconsistent results. Explore alternatives to the NO_LOCK hint to get your queries to run …