Missed it due to the typo too.

Thanks for the question Steve. I've never used THROW before. Now that I know how it differentiates from RAISERROR, I have some ideas of where it could come in handy....

Nice question about a important topic. Thanks Steve.

I should have gone with my gut on this one. When I got the same results using rank and dense_rank, I decided I must be misunderstanding the intent of the...

i remember reading this editorial the first time around and my opinion then is still the same as it is now. A big NO THANKS!

I had seen this same behavior firsthand when I was testing out some triggers before I utilized the inserted table values to limit how the trigger fired. A good question...

Nice question. Thanks!

Fun question. Thank you Shiva.

A nice example of the capabilities for using SQL Server to recreate interesting calculations. While I am positive I will never have to know what Armstrong...

I don't use synonyms but had always wondered what would happen if I ran into a synonym such as this. My default schema is dbo and I tested it and...

Nice question Steve. I was impatient and did not look far enough into the documentation to get this right. I just chose the drop and recreate option because that has...

Raghavendra Mudugal (8/21/2014)

---

TomThomson (8/21/2014)

---

It's valid...

Answered too quickly on this one. I knew it could be run against tempdb but ignored that for some reason. Had I thought about it for another second then I...

Nice and easy one. Thanks Tom.

TomThomson (8/13/2014)

---

Hugo Kornelis (8/12/2014)

---

It's been like that for a long time already. In some places, the QotD author is presented with the correct author. In other places, it is presented...

SQLRNNR (8/8/2014)

---

TomThomson (8/8/2014)

---

+1

Actually I clicked 2 (query and namespace) and then noticed that clicking the second cancelled the first because...