The Curious Case of… setting up a server for DBCC CHECKDB
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
Menu
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
Erin’s new course is called SQL Server: Understanding and Using DBCC Commands and is just over 2.25 hours long. It covers all the documented DBCC commands and a
Here’s an interesting question that came up in our IEPTO1 class in Chicago this week (paraphrasing): I was doing a demo recently where I was demonstrating
This is a quick post to let you know about a bug that a few people are hitting when running DBCC CHECKDB. The symptoms are
(Check out my Pluralsight online training course: SQL Server: Detecting and Correcting Database Corruption.) This is a question that I was sent over email that
A couple of week ago I kicked off a survey about the extent of your experience with the DBCC WRITEPAGE command. Here are the results:
I’ve just heard from our good friends at Pluralsight that our two latest online training courses are now live and available for watching! My latest
After going back and forth with someone with a corrupt master database, I’ve just discovered a bug. And unfortunately it goes back to SQL Server
A while back I kicked off a survey asking what mechanism you use for running your regular SQL Server database maintenance. Here are the results:
Back in February I ran a bunch of performance tests of DBCC CHECKDB on SSDs, to evaluate the effects of degree-of-parallelism (DOP) and various options
[Edit 2016: The team ‘fixed’ the problem in SQL Server 2016 by skipping consistency checking these indexes unless WITH EXTENDED_LOGICAL_CHECKS is used.] It’s no secret
There’s cool mechanism that the buffer pool has called disfavoring, that sometimes kicks in to prevent pages from a different database being flushed from the buffer pool
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
Last week on the MVP distribution alias there was a discussion on undocumented DBCC commands and someone asked why so many potentially useful DBCC commands
The September SQL Server Magazine articles are now available on the web and include my latest feature article on Using Database Repair for Disaster Recovery.
[Edit 2014: there’s an additional bug in SQL Server 2012/2014 – see this post for details.] More details are in KB article 919142, which was
(Check out my online training courses: SQL Server: Detecting and Correcting Database Corruption and SQL Server: Advanced Corruption Recovery Techniques. We can also help you with disaster recovery.) Yesterday on
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
The very worst piece of advice I ever saw on the Internet was in response to someone asking on a SQL newsgroup ‘how can I
Here’s a question that came up recently: if I’ve upgraded a database from SQL 2000 or before, how can I tell if the data purity
In this week's survey I'd like to know how often you run consistency checks on your *most critical* production database, regardless of *how* you run
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
There are a couple of issues that I’ve heard of in the last few weeks (one while onsite at a customer) and I think they might bite
This week's been a busy one on the forums and Twitter, with lots of interesting problems people are hitting. One of the things I've noticed
This is a true story, and unfolded over the last few days. It’s deliberately written this way, I’m not trying to be patronizing – just illustrating
Hopefully all of you reading my blog already know to use the WITH ALL_ERRORMSGS option whenever you run DBCC CHECKDB (which is now the default
This has come up a few times now, most recently in an email question this morning – subsequent runs of DBCC CHECKDB show varying numbers of
Recently there’s been a spate of people noticing strange behavior from active transactions when DBCC CHECKDB (or any of the other DBCC consistency checking commands
Just saw this on a forum – running REPAIR_ALLOW_DATA_LOSS on msdb to cope with corruption. Yes, this will work but it's certainly not safe and
(Continuing my habit of blogging while Kimberly’s presenting – at least I’m not on stage this time…) In early versions of SQL Server, it was
A thread cropped up on SQLServerCentral involving IAM chain corruption (see Inside the Storage Engine: IAM pages, IAM chains, and allocation units for details of IAM
Microsoft SQL Server 2008 Internals finally starts to roll off the presses at Microsoft Press today! For me this is the first time in
The April edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
As you may know, DBCC CHECKDB (and some of the other DBCC CHECK*) commands use an internal database snapshot to get a transactionally consistent view
In SQL Server 2000 and before, the symptoms of database corruption would occasionally manifest themselves as asserts, such as: SQL Server Assertion: File: <recbase.cpp>, line=1378
This blog post describes the demo "2 – NC Indexes" from my Corruption Survival Techniques conference session from various conferences in 2008. The links to
For those of you who couldn't make it to a conference this year where I presented my Corruption Survival Techniques session, the folks at TechEd
This blog post describes the demo “1 – Fatal Errors” from my Corruption Survival Techniques conference session from various conferences in 2008. The links to
Now, I’m very thick-skinned and I know there are always some people in a conference session who don’t agree with everything I say (that’s human
This blog post explains the demo scripts and databases I've posted to cover all the Corruption Survival Techniques and DBCC CHECKDB sessions I've presented at
Very exciting! The SQL Server 2008 Internals book we're working on with Kalen is now available to pre-order on Amazon, ahead of the planned
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
Every so often I’ll see posts on the various data corruption forums discussing causes of corruption. In this post I want to debunk some of
Following on from my previous post on boot pages and boot page corruption, I’ve been asked about file header pages – and I was already
Well, almost… Kimberly and I have agreed to co-author the upcoming SQL Server 2008 Internals book with our good friend Kalen Delaney. This is the
Today I presented my brand new session Surviving Corruption: From Detection to Recovery at TechEd. I had a lot of fun putting together the demos, presenting
(I’m actually on-stage here at TechEd doing the DAT track pre-con with Kimberly – she’s on now until lunch so I’m catching up on forum problems…)
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.