Month: July 2015

SQL Server Tables – BTree or Linked List?

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

Tagged with: , ,

Database Corruption Challenge #10

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

Tagged with:

Database Corruption Challenge #10 Grand Finale – Starts Friday

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

Tagged with:

Database Corruption Challenge #9 – How I Corrupted the Database.

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

Tagged with: , , ,

Database Corruption Challenge #9 Complete

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

Tagged with: , , , , , , ,

Database Health Monitor – Historic Waits

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

Tagged with: , , , , , , ,

Corruption Challenge 9 Update

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

Tagged with: , , , , , ,

Database Corruption Challenge #9

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

Tagged with: , , , , , , ,

Database Health Monitor Version 2 Released

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

Tagged with: , , , , ,
Top