Good one!!! Thanks for the question.

Gail,

Easy and straight forward question.

Thanks,

Good question.

Good question.

This is really a good question.

Good question, thanks Steve.

Jason,

Great question with the exposure of NEWID(). I got it wrong but i learnt something today. I am not worried about the points we get here but am more interested...

Good question.

This is a good question, though it is confusing but it as per the question, it is said that which of the statements can be executed to create index on...

Good question, learnt new feature of Denali today. Thanks

Thanks Steve!!! I knew today is April first.

Good question and learnt something new today.

Good Question, thanks.

Thanks all for the comments and suggestions. You all are correct that i should have mentioned the version of SQL Server in the question. I agree with you all that...

I think question is clear because I have mentioned SQL Server 2008 R2 Edition. I know backup compressions existed in SQL Server 2008 EE but not in SQL Server 2008...