Anyone who’s experienced database corruption knows they do not want it to happen again. Corruption repair is stressful and could require money and downtime you can’t afford. In some cases, there is no “repair” just rebuild. Unfortunately, no database is immune from server corruption, but there are certain alerts and specific practices that when implemented will greatly lessen the impact …

Preventing Server Corruption – Video Read more »

Occasionally you need to take inventory of how much free space each database has. You can find this quickly and easily in Database Health Monitor, but if you want to get it programmatically you can do it with the following query. This query has been tested on SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, and 2019. This …

Query to Find Free Space on All Databases Read more »

Steve Stedman and the Stedman Solutions Team celebrate the 10 year anniversary of Database Health Monitor. Kiana talks to Steve about this tool he built, how it’s evolved, why its useful and its plans for it in the future. Go to http://www.Databasehealth.com​ to download this free tool today! STEVE: This is the 10-year anniversary of database health monitor and it …

10 Year Anniversary of Database Health Monitor Read more »

The following is chapter 6 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. Thinking of the proverb “two heads are better than one” makes me think, it really depends on the people. Two people working together are …

Multiple CTEs in a Query Read more »

Take a look at the video on our Youtube channel. 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 ugly of corrupt databases. What things people did to make it worse, and what people did to make things better. Related links:

Microsoft has just release an cumulative update for SQL Server 2017 CU 23. I am always interested in fixes to DBCC CHECKDB and DBCC CHECKTABLE. There was one fix related to CHECKTABLE that fixes an issue where the session gets killed when you run DBCC CHECKTABLE with PHYSICAL_ONLY due to disk full. The session remains in KILLED\ROLLBACK state and threads …

New cumulative update for SQL Server 2017 Read more »