nice question. thanks

For 2005, i get 0 rows returned for both the statements. Why?

apart from al syntax discussions, I enjoyed this question. Thanks QoD

I do not like this kind of question at all. The QotD should be a learning opportunity, with clear questions and no tricks.

There is nothing to be learned from this...

When rows are marked as deleted after a DML operation and the transaction is committed, the rows become Ghost records.

I got it right 🙂

nice question but setting arithabort on gives completely diff solution

Easy one.. but a good question 😉

an easy question:-D

if a clustered index already exists, SQL Server will enforce the Primary Key constraint with a nonclustered index

False, if a clustered index already exists, DB will enforce the Primary Key constraint with a nonclustered index

:cool::satisfied:Clustered index is newly created or rebuilt, it is physically and logically ordered as per the cluster key(s). But when data is inserted or the clustering key values are updated,...

got it right... this time with my understanding..........:cool:

Compression occurs in the storage engine and the data is presented to most of the other components of SQL Server in an uncompressed state. This limits the effects of compression...

The answers are different for each line.

In prefix compression, does the entire prefix stored in the header need to match the data to be used?

No

if I have a prefix of...

Nice Question, QotD.. keep us bugging like this only 🙂