Day 10 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at how to use multiple CTEs in a query. These queries will be using that database that was set up in a previous posting on the CTE_DEMO Sample Database, if you haven’t set up the sample database, download it and set it up now. …
Day 9 of Common Table Expression Month (June) at SteveStedman.com, today I will be building on the intro to recursive CTEs from two days ago and on showing how a recursive CTE can be used to calculate information about dates of the year from yesterday. This would be useful if you were trying to build a calendar. These queries will be using that database …
Day 5 of Common Table Expression Month (June) at SteveStedman.com, today I will cover concepts around the scope of a CTE. The queries in the video will be using that database that was set up in a previous posting on the CTE_DEMO Sample Database, if you haven’t set up the sample database, download it and set it up now. Where is …
Day 3 of Common Table Expression Month (June) at SteveStedman.com, today I have a video presentation extracted from my normal SQL Saturday CTE presentation. The queries in the video will be using that database that was set up in a previous posting on the CTE_DEMO Sample Database, if you haven’t set up the sample database, download it and set it up …
As the month of May comes to an end so does DBCC command month at SteveStedman.com. I didn’t cover all the DBCC Commands this month, but here is what I did have time to cover: May 1st – DBCC CheckAlloc May 2nd – DBCC CheckCatalog May 3rd – DBCC CheckConstraints May 4th – DBCC CheckDB May 5th – DBCC CheckFilegroup May 6th – DBCC CheckIdent May …
It was a great day at SQL Saturday today. I was able to preview my Common Table Expressions Book at my Common Table Expressions presentation. The presentation was great, the room was packed, and there were lots of great questions. Here is the lineup for the room that I presented in. Just before me was Rick Morelan presenting on SQL …
I will be presenting at SQL Saturday #212 in Redmond tomorrow. My presentation will be on Common Table Expressions, and it is the first CTE presentation since my Common Table Expressions book released. I have updated the presentation to include a number of new things relating to CTE’s that I figured out while writing the book. This will be my …
Presenting at SQL Saturday #212 in Redmond Tomorrow Read more »
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 feedback, I am updating my presentation for SQL Saturday 114 in Vancouver to include some additional content. One question was how does the performance compare between a recursive CTE to generate a hierarchical tree path …
Hey there, SQL enthusiasts and fellow learners! Grab your spot and capitalize on our special pricing. I’m genuinely excited to share something I’ve been working on: the Everything SQL Server Bundle. Whether you’re just embarking on your SQL journey or you’re already deep into the SQL world, I believe this bundle will add significant value to your learning curve. Inside …
Welcome to all SQL enthusiasts! We’re ecstatic to introduce our comprehensive offering – The Everything SQL Server Bundle. Whether you’re just starting out or a seasoned professional, this bundle promises to elevate your SQL Server prowess. Course Lineup We’ve curated a diverse and powerful set of courses to ensure you’re equipped with holistic SQL Server knowledge: SQL Server Interview Questions …