Current SQL Server course coupon codes and on going deals you can only get from Stedman Solutions! 25% Off in July! Coupon Code: DATABASEHEALTH Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn. With this course you will also receive 20 Database Health Monitor server …
We hope you enjoyed last month’s Common Table Expressions theme and all the video tips and blog posts we released. July we will be focusing on Database Health Monitor and we will be releasing some SAVINGS as well as some TIPS AND TRICKS! So make sure to follow us on social media, sign up for our newsletter or check back …
Recursive CTE Examples Wed, 29 Jun 2022 Transcription of Video: One of the things I like play with is performance and pushing things to their limits. So what I want to do next is see how far can we push this sum of parts? Can we d Read more… Steve Explains how to build a Recursive CTE Tue, 28 Jun …
Current Stedman Solutions SQL course coupon codes and on going deals you can only get from Stedman Solutions! 50% Off Our Newest Course! Coupon Code: FEB-RELEASE50 Using our instruction and scripts included in this course you will successfully configure email notifications when blocking occurs. Address blocking BEFORE it takes down your system. See All Our Online Courses! On Going Deals …
Ok cool Stedman Solutions is having CTE (common table expressions) month in June. What does that mean for you my reader? Well let me share all the goodies I have to offer this month! Next month I will be releasing……. Over 15 CTE videos with topics ranging from a memory table to recursive CTE’s Common table expressions hot tips A …
Russian Nesting Dolls If you have ever seen the Matryoshka dolls known as the Russian nesting dolls or babushka dolls they are very interesting. They start with a large wooden doll that when opened contains a slightly smaller doll, then inside of that one an even smaller doll. These dolls often have five to eight dolls nested inside of each …
Years ago 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 »
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 CTE query once or twice? For instance: ;WITH deptCTE(id, department, parent) AS (SELECT id,department,parent FROM Departments)SELECT q1.department,q2.department FROM deptCTE q1 INNER JOIN deptCTE q2 ON q1.id = q2.parent WHERE q1.parent IS NULL; The following execution plan is produced showing that the Departments table is hit twice with a table scan each time with the same cost. …
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 into a CTE, it can make sense to do multiple. To use multiple CTE’s in a single query you just need to: Finish the first CTE Add a comma, Declare the name Optional columns for …
Yesterday I blogged about submitting to SQL Saturday Denver, which is about 5 months away, after writing that post, I realized that I haven’t even blogged about SQL Saturday Redmond which is occurring in just over 2 weeks. SQL Saturday #393 Redmond marks just 3 years since my first time speaking at a SQL Saturday #108 in Redmond. So lets …