TechEd demo: nonclustered index corruption
This blog post describes the demo "2 – NC Indexes" from my Corruption Survival Techniques conference session from various conferences in 2008. The links to
Menu
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
Here's another corruption bug that people are hitting on 2005 SP2 – something I didn't know about until today. The situation is this: a table
(Posted with permission of the dev team) Here's an interesting bug that people are hitting. I found out about this while here in Barcelona at
(Quickie post #3 while it's Kimberly's turn to lecture this morning – better pay attention now before I get into trouble) Gail asked a (paraphrased)
(Quickie post #2 while it's Kimberly's turn to lecture this morning…) Greg asked a question regarding the script I posted to examine buffer pool contents (paraphrased)
(Quickie post #1 while it’s Kimberly’s turn to lecture this morning…) I had a comment on my post dealing with suspect databases, saying that the
(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
I've had a few follow-ups on my two posts about boot page and file header page corruption – asking if its possible to do single-page
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
Now that I’ve done all the business-related blog posts, back to the good stuff to stop people complaining! Something that’s cropped up a few
Well, we’re just back from vacation (photo blog post to follow) and I’ve heard that the feature article on Effective Database Maintenance I wrote for 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…)
Before I start, I want to make it clear that you can only hit this bug if you ALREADY have corruption, that it’s quite rare,
My first magazine article is in print! I’ve taken over the bi-monthly SQL Q&A column for TechNet Magazine and I just received the June magazine
Many times I've been asked to do a blog post about creating Agent alerts, and given that today I demo'd it as part of our
This is a really interesting question that came up in the Microsoft Certified Architect class I’m teaching at present – if a database has torn-page
[Edit: From 2016 SP2 onward, you can use SELECT DATABASEPROPERTYEX (‘dbname’ , ‘LastGoodCheckDbTime’ ); instead] This came up several times during the week so I
Here’s an issue that I thought was a one-off but it just popped up again over the weekend so I want to publicize it. DBA
In my previous post on interpreting DBCC CHECKDB output, plus in my DBCC Internals session at TechEd IT Forum in Barcelona yesterday, I mentioned there
This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so
Last week at SQL Connections someone said that CHECKDB’s output is ‘useless’. Given that I wrote CHECKDB for SQL Server 2005 I was only mildly
As promised, here’s the first of the grab-bag of questions we were asked during conferences. I’m blogging a selection of the stuff I noted down. These
(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’
(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
One of the hottest features in SQL Server 2005 is database mirroring, and it’s helped many companies implement successful and relatively inexpensive high-availability strategies. In
(Check out my online training course: SQL Server: Detecting and Correcting Database Corruption.) In this post I want to describe the two worst things I
Now that I have a little more time on my hands I’ve been jumping back into some of the online forums. Last summer I posted
One of the comments I received recently is below: Hi Paul, If the corruption happens to be related to I/O Erros and there is nothing
This was originally posted as two posts on the SQL Server Storage Engine site. It was very popular so I’ve combined the two posts together
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.