Cool!

I'd turn page checksums back on as soon as the broken page is no longer part of your table.

Don't worry about the drink - I had enough last night (unfortunately)...

Hmm - I'm concerned that CHECKDB couldn't repair the error. It's obviously a leaf-level page in the clustered index that's corrupt, but that should be a simple repair - deallocate...

Here's the blog post IAM page corruption examples. The 8946 doesn't crop up after all - that's for things like GAMs and SGAMs. I've zipped up the corrupt databases in...

Yeah - forgot to put a smiley in there 🙂

For a 2576 error, the only time the first IAM page ID will be NULL is when the code knows that...

Because I wrote the code. The NULL page Id is a special case.

It's also documented in MSDN as being the meaning in that special case - see http://msdn.microsoft.com/en-us/library/aa258785(SQL.80).aspx

Gail - in this case you're wrong.

These errors indicate that the first IAM page for an index does not have an entry in sysindexes. This commonly occurs when someone manually...

Look in Books Online under 'LEFT' and it'll give you a link to the String Functions section.

This isn't a data corruption question (which this forum is about) and looks like a homework question...

See Kimberly's blog post 8 Steps to better Transaction Log throughput and my blogs

Search Engine Q&A #1: Running out of transaction log space and

Search Engine Q&A #23: My transaction...

ok, but this is an error caused by IO subsystems, not SQL Server. One of the IO subsystems involved had a problem that caused this. Can you run the following...

You'll need to fix this before upgrading, using the method that gives you the smallest amount of downtime and data-loss (whichever is more important to you).

Did you have a power...

No way should this be a make or break question IMHO.

There's a survey widget-thing embedded in that blog post - is it...

It's part of the full-text system, but only in 2005 and before 🙂

I don't think it makes someone a bad DBA if they don't know it, but someone who does...

ok - I blogged about this - go vote if you're interested: What's a valid question for a DBA interview?

Thanks