That was a very good explanation. I appreciate it.

Thanks for an easy start to the week, even though it's not Monday yet! 😉

Brian.Klinect (2/18/2015)

---

I learned to today that I can set permissions at the column level. Never even considered trying to do that before.

I really liked the story that went with...

Nice question to highlight the differences in ways that NULLs are handled by different operations. Thanks!

Brian Hibbert (1/29/2015)

---

I think I'm not quite understanding what SOME (or Any) actually does.

A quick read of the BOL says the return type is Boolean, but it's not...

Thanks for the question Steve. Liked it a lot.

+1 Still waiting for Hugo to rewrite BOL so they are more useful. 🙂 In his spare time of course.

Hugo Kornelis (1/12/2015)

---

I thought that using SELECT would have started the implicit transaction, but I tested after answering this question and nothing changes if I use SELECT instead of PRINT....

Easy one. Thanks for the Christmas gift Steve!

Hope everyone who is not offended by the statement has a Merry Christmas! I hope the rest have a great day too....

Nice easy one for a Friday. Thanks for submitting the question!

Nice question. And I'm only partially motivated in my praise by having got it correct.

Had to think about it for a while - almost went with the dropping an index...

Heals (12/16/2014)

---

Good question - got it wrong, but learnt something so all to the good!

Never come across it before as I always use aliases, but good to know when I...

Seemed pretty much common sense. Glad it was. Thanks for the question!

Thanks for the question. Seemed easy enough, but was sufficiently challenging for a Monday.

Saw Koen's plug for his blog. Can we get him to rewrite BOL too?

Chiefly Confused (11/5/2014)

---

I also believe the answer is misleading. The select will return 1 row, 1 to 9 times, each one is a separate select of 1 row. ...