EXCELLENT question, Carlo, very interesting demonstration of query optimization. Thanks for a question that made a lot of people think hard.:-)

Aaargh! I should have gotten that one. I knew that SQL adds the "uniquifier", but I couldn't remember how long it is.

I like the long names that are allowed in...

Thanks for the question, Steve, it has created a fascinating debate.

Regardless of the merits of adding semicolons at the end of all statements (something which I don't do, but should),...

I like Visual Studio a lot, and use it (VS 2012) for SSIS work, but I use SSMS for my SQL development work, primarily because I'm used to it.

Fantastic question, Tom, and very interesting, as I expected when I saw that you wrote it. I learned something today (which is the whole reason for QotD).

Nice question, Steve, thanks.

Thanks, Vimal, for the nice question. I also had never contemplated removing the only column in a table.

Nice question, Carlo. Thanks! 🙂

Nice, easy one. Thanks Steve.

Nice, fairly easy question to end the week. I haven't worked with filestream data yet, but it makes sense that if you are storing data in the local file system,...

Nice simple question, thanks.

Nice question, Gabe, although it would have been better if you had included more options so finding the solution didn't just boil down to "how is -5 converted". One possibility...

Great question, Steve. Two out of three isn't too bad, is it? :hehe: Thanks, I learned something.

Thanks for the excellent question, Lance. I have to admit, it tripped me up. I can see where that would be a problem in queries. I'm fairly strict about using...

Thanks for the fun question, Don. I at first thought it...