Me too - great question to make us thinkg and research.:-D

Nice "easy basics" question to start the week - thanks!

Counting that many similar characters is not that easy though!!!

Why is this a multiple choice question... The same question was asked about SQL 2008 R2 (http://qa.sqlservercentral.com/questions/Indexing/69984/) back in 2010 and only one answer was available and the...

Seems I can only Ditto all the quotes on the second answer! Got me I guess

Thanks for the great question Hugo. Strange not to see any replies from you in...

A great topic to test knowledge, but I think it kind of gets lost within the context of the question! :hehe:

What is the point of the tricks in the question...

Interesting question and have learnt something today, however I have to agree that the answer is actually wrong, as if you want to add any options to the DBCC command...

Great question - thanks.

Does make you think before answering, especially given the amount of information in the question.

Agree with most that TempDB is also a correct answer, but I guess that was the trick they were trying to catch! 😉

Nice Question. Thought there was a catch to the question and had to think carefully.

Have just run the test on a 2012 instance and got the same result - 2...

Nice Question - made me read up in BOL and actually learn something useful.

Thanks

Great to see questions on 2012 now, but also have to ask what is up with the "other" in the question?

Luckily I re-read and checked this a few times. First pass reading I thought it said deleted a row! Couldn't understand what that would really be checking!

As a number of...

Nice easy one to start the week - thanks.

Thanks for the nice easy question. Had to think about the objects held in the system views, but figured that wasn't what you were testing and where trying to cover...

I agree that the answer was one of the last two, and although I got it right by elimination (I figured you were testing the looping logic rather than "unlimited"...