Find out more about the Week 3 Challenge on the overview blog post. The winning solution, was submitted by Randolph West with the following steps: I created a dummy database with the same name, set it offline, deleted the files, dropped in your LDF, brought it back online, and did a tail of the log backup with NO_TRUNCATE to bypass …
Week 3 – Corruption Challenge – The Winning Solution Read more »
It is my pleasure to announce the winners in the Week 3 Database Corruption Challenge. But first how about a rundown of challenge. The challenge was issued at 10:00pm (pacific time) on Friday night. Yes, this was a difficult time for those on the East coast of the US, and if you are from EST, next week I promise the …
Each week this page will be updated to show the current score total in the Database Corruption Challenge. This list has been updated as of July 20th, 2015 at 4:00pm (pacific time). Rob Farley in a solid lead with 25 points after earning 6 points by being the first to solve week 10. André Kamman just moved into second place moving …
Welcome to the third week of the Database Corruption Challenge (DBCC), this is the third in an about weekly competition. Here is how it works; I have created a corrupt database, hopefully more corrupt or more challenging than the previous week. I then solved the corruption myself, in order to prove that it is possible to fix, without data loss. This week …
It is my pleasure to announce this weeks winners in the Database Corruption Challenge – Week 2. There were many great solutions submitted, and I hope that everyone learned something from this weeks challenge. My favorite part of the whole challenge was this post on Twitter… The whole goal of the Database Corruption Challenge is to help everyone …
Welcome to the second Database Corruption Challenge (DBCC), this is the second week in an about weekly competition. Here is how it works; I have created a corrupt database, hopefully more corrupt or more challenging than the previous week. I then solved the corruption myself, usually in 2 or 3 different ways in order to prove that it is possible …
Welcome to the Database Corruption Challenge (DBCC). If you are just finding out about the challenge, and you would like to give it a try on your own, then don’t click the links to the solutions. Give it a try, see how you do, then check the solution. Database Corruption Challenge History Week 1 Database Corruption Challenge 4/11/2015 won by Brent Ozar. …
Being day 22 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC OUTPUTBUFFER. I missed a few days on the DBCC Commands due to attending SQL Saturday in Redmond, and the release of my book on Amazon.com. I am now back on track to finish out the rest of the month with more DBCC commands. Description: …
Being day six of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKIDENT. Description: DBCC CHECKIDENT is used for check on the current value in the identity column for a table. It also reports on the largest value in that column. DBCC CheckIdent can also be used to update or set the next identity value on …
I came across this example when preparing my CTE presentation for SQL Saturday in Portland OR in 2 weeks. Which produces the following output.