Nice, simple, uncomplicated question for Monday morning. Just what we like 🙂

Thanks for the point

Yay! It's nice to get the point on a Friday.

Nice simple question, not too taxing, thanks.

Nice back to basics questions, nice and easy despite my insane attempts to find the catch... :crazy:

Thanks 😀

Oof! fluked this one.

Knew the first 2 were right, and that columnstore was non-clustered. Guessed it was probably an XML index and decided "for value" would be more useful.

Phew! 🙂

Richard Warr (7/27/2012)

---

By not choosing the option which said

I earned points quickly and...

Does seem a strange rule, good question thx

Great question for a Monday, not too easy to get the brain matter warmed up, thanks.

When examined from a programmers background the answer came quite easily.

DBCC CHECKDB is designed to look for consistency errors in the database, so why would finding them be an exception...

With the presence of a very young family, and a lack of travel with work, I'm unable to read as much as I would like to. I'll manage only a...

Great question thanks

Wot he said 😛

Thanks for the easy point. I was able to recognise all 4 system databases from the descriptions given, a nice wee test.

Feels like the first question in a SQL exam....

Great question Kenneth, refreshed the old memory banks there 😉

paul.knibbs (7/10/2012)

---

Pretty confident the answer would be an error, but I had to go and test it because the question specified SQL 2012 and I thought they might have changed...

Nice and simple back to basics, perfect for a Monday.

Thanks 😀