Ok, very different from Recovering...

Means that there's either a database restore in process, a restore has been done and the norecovery option specified, or someone has done a log backup...

There are two things that can cause the first run to be slower:

- Fetching of the data from disk rather than memory. Counter with CHECKPOINT and DBCC DROPCLEANBUFFERS

- Generation of...

It's perhaps better to say that they don't participate in transactions.

Table variable changes are still logged, they have to be (all...

Absolutely. CheckDB reads every allocated page in the entire database, hence you're going to have a lot...

Recovering or restoring?

I ask, because on this thread you said recovering and on another you said restoring. Which is it?

CirquedeSQLeil (4/1/2010)

---

I enjoyed the blog post. I felt silly that I hadn't thought of a great idea...

It's not a bug.

CheckDB requires a consistent view of the database in order to do the check. In SQL 2005/2008 in order to do so, it creates a hidden database...

Try:

IF NOT EXISTS ( SELECT 1 FROM sys.columns WHERE [object_id] = OBJECT_ID('dbo.Service') AND [name] = 'NewColumn')

BEGIN

CREATE TABLE tmp_ms_xx_Service

(Column1 uniqueidentifier NOT NULL,

Column2 char(10) NULL,

Column3 varchar(100) NOT NULL,

Column4 char(1) NOT NULL,

NewColumn varchar(15)...

They're created when SQL encounters an access violation. If you're not interested in debugging or sending to CSS for debugging, you can delete.

Unless, of course, it was someone from twitter complaining 'cause I said I hadn't had a complaint. Email...

JustANumber (4/1/2010)

---

Unfortunately, my column insert is not performed with an ALTER statement. I first create a temp table where the new column is 5th out of 8 columns. 2)Insert...

Now I have someone whining about my april fool's blog post. 🙁

Yes, but it's the switching to simple, not the shrink, that breaks the log chain.

Steve Howard-434180 (4/1/2010)

---

By the time I got to the point where you let us in on the joke, I was already planning an email to my teammates to say WTH...

Stick a GO between the ALTER TABLE and the update. Otherwise, at parse-time, the column doesn't exist and throws an error.