Very good question indeed. Had to run the code and go through lots of data online before marking correct answers. Definitely was a new thing to learn. 🙂

Really good question. And equally good explanations by kingston and Hugo. Cheers. 🙂

Seriously no fuss about the extra ordinary out of the box challenges to the question here ???? :-)...

These kind of quesitons should be asked regularly as they keep brushing your basics. I feel these concurrency theories get complex even not looked out for a while. So a...

Very good question on locking. Had to look into BOL but clarified myself on RangeS-S, RangeS-U, RangeI-N and RangeX-X. The following MS technet link provides a pretty good view on...

Pretty easy one. Thanks a lot. 🙂

The trick got better of me. 🙂

Wonderful question. I have never worked on FTS. So in order to get the correct answer, I had to dig MS technet site and bingo. learned something new. 🙂

Good question on indexes on views. 🙂

Good QOTD. And some good clarification by Hugo (as always). 🙂

+1 once more... 🙂

Koen Verbeeck (7/19/2013)

---

Michael Riemer (7/19/2013)

---

+1

Don't understand the logic of the insistance on renaming something that everyone...

DivyaMohankumar (7/30/2013)

---

Good question.... I wish to Share some of the points:-P:

->DBCC CHECKDB - Checks the logical and physical integrity of all the objects in the specified database.

->DBCC CHECKALLOC – Checks...

very good question. 🙂

Nice question. Good information about return functionality. 🙂

Easy one for those worked on Identity columns. 🙂