Is a clustered table in SQL Server a BTree or Linked List? When you first learn about the structure behind clustered indexes in SQL Server, you find out that the clustered index is structured as a type of B+Tree where queries that make use of the tree structure to find the rows that you are looking for. However it is not the common …
Welcome to Week 10 of the Database Corruption Challenge. I have created a more corrupt, and perhaps more diabolical corruption scenario than previous weeks. This is the last week of 10 in the Database Corruption Challenge. Here is how it works; I have created a corrupt database, then solved the corruption myself in order to prove that it is possible …
The Database Corruption Challenge – Grand Finale The final challenge #10 in the Database Corruption Challenge starts this Friday (July 17th) at 6:00pm (Pacific Time). After 9 other challenges we come to the final competition in this series. Many have competed, many have won, this is your chance to participate. For those who have succeeded in all the other 9 Database Corruption …
Database Corruption Challenge #10 Grand Finale – Starts Friday Read more »
I was asked how I caused the corruption in Database Corruption Challenge #9. Here is how I did it. To cause the corruption, I used the undocumented DBCC WritePage, however the same thing could have been accomplished by detaching the database, opening it with a hex editor, and then re-attaching the db. DBCC WritePage WARNING: DBCC WritePage is a dangerous …
Database Corruption Challenge #9 – How I Corrupted the Database. Read more »
Database Corruption Challenge #9 has completed with 19 winning participants, you can take a look at the scoring page for exact details. The first to solve the challenge this week was Eduardo Rezende who provided the winning solution just 58 minutes after the challenge began. The second winning solution arrived less than a minute after the first, so it was a …
With the recent release of Database Health Monitor Version 2.0 I have decided to focus on of blogging about the features and benefits of the Database Health Monitor application. There are some incredibly valuable features that are often overlooked. The purpose of this blog series is to present some of the features of the product. If you haven’t tried Database …
Just about 24 hours after releasing Database Corruption Challenge #9, so far there have been 15 winning solutions. The first to submit a winning solution was Eduardo Rezende. The scores have been updated. Rob Farley is back in the lead with 18 points, second place is Raul Gonzalez with 17 points, followed closely by Neil Abrahams, André Kamman, and Patrick Flynn with …
Welcome to the ninth competition of ten in the Database Corruption Challenge. This week I have created a database and then corrupted one or more parts of that database, and your goal is to fix all of the corruption without losing any data. There is a total of 4 points available this week: One point for being the first person …
After 4 years of beta and 5500 installs of Database Health Monitor beta releases in the last 2 years, Database Health Monitor version 2 is finally complete. It is no longer in beta. If you are curious about the history of Database Health Monitor, take a look at my post from earlier in the week. Here is a preview of …