The following is chapter 5 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow along with the examples in this chapter. The script mentioned in this chapter is available at http://SteveStedman.com. Hierarchical CTEs When looking at the table of contents for a book it is generally represented as an outline of some kind utilizing indentation, …
Since installing SQL Server 2019 CU9, I have been getting lots of errors about NO DEK Update for almost every file. Here is an excerpt from the SQL Server log file. 182 2/20/2021 2:07:46 PM spid25s Refresh DEK for DBID: [5] File Id: [1] – Copying encryption state183 2/20/2021 2:07:46 PM spid25s DBID: [5] File Header for File Id: [1] …
As part of the CTE book there is a sample database that all the queries use. You can download the create script for that sample database here and run it in your local SQL Server, or on a test SQL Server: Due to the security settings of the web site, and many download checks, I was unable to anme the …
The attached PDF is the slide deck for my Introduction to Corruption presentation from Feb 17th 2021. I hope you enjoyed the session.
We are 2 days away from the Introduction to Database Corruption free presentation. On February 17, 2021 at 6:00pm Pacific time we will be presenting a free webcast training on SQL Server Database Corruption. After repairing dozens of corrupt databases over the last 6 years we are going to share our experiences. Some of the good, the bad, and the …
The following is chapter 4 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow along with the examples in this chapter. The script mentioned in this chapter is available at http://SteveStedman.com. Recursive CTEs Have you ever solved a maze puzzle on paper, or had the opportunity to visit a …
I received this question from someone visiting the blog, and realized that rather than just replying to them, it might be good to put the options out there for everyone to see. Hello, I came across your website and it seems that you are an SQL expert, I’m just getting started. I was wondering can you please give some guidance on …
So often I run into examples where someone is inserting a row and trying to get one of the values from that row that was just inserted. For instance an integer identity id value or just to be able to see the row after it was inserted. Introducing the OUTPUT clause, and often overlooked or forgotten tool in SQL Server. …
At our February webinar presentation on Database Corruption, Stedman Solutions will be giving away 3 daily checkup subscriptions one 3-month subscription, one 6-month subscription and one 9-month subscription. A value of $300, $600, and $900 each! If you are not familiar with our SQL Daily Checkup product, here is how it works. You need to have Database Health Monitor (free) …
Prize giveaway at the February webinar presentation Read more »
The following is Chapter 3 from my Common Table Expressions book it its entirety. CTEs Instead of Derived Tables One time I was handed an eight page print out with an 8pt font showing a single SQL statement. It was handed to me with a question about why it was not returning the right data. After looking the query over …