Good question, but the answer from MS is not really applicable, since we have a sub-query expression and not a TVF in the QTOD example.

The more verbose explanation is documented...

I thought I had 2 Choices:

12:18 AM - Full backup data reading of QotDDatabase ends

12:19 AM - Transaction 4 on QotDDatabase commits

12:19 AM - Full backup transaction log reading...

Very interesting QODT.

Here a little additional information that I find helpful:

1. The most important explanation from the Support Link:

When the DBCC CHECKDB statement detects a consistency error in the database,...

The 1 percent must come from the Author (or Steve, the point nicker):-P

10 answers?!? 😛

Depends on...

Poorly worded question. There is no way for the reader to identify if the author meant implicit or explicit index creation. And the fact that both Primary Keys AND Indexes...

Hi Hugo,

I did test it, and the table constraint (not column constraint) gets created, even though there is no comma in between.

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)...

Hm, I am a little confused because of the missing comma before the CONSTRAINT declaration. That does not seem to be required based on a first test. But I checked...

Looks like there is a join predicate missing somewhere...

WayneS (1/19/2012)

this article only talks about the Analytic functions. You might want to look at my previous article The OVER Clause enhancements in SQL Server code named “Denali”, CTP3[/url].

Basically, the...

Great information, thanks for that.

To me it was not clear immediately, what...

Thanks, that makes sense.

I am not sure I understand the explanation.

I would expect to find a row for the trigger in sys.all_objects, if it is said to be stored as an "object" in...

Got it wrong because I did not see that EventID was the PK.

But to be honest, i don't agree with the explanation for why the last option is not...