Took some time to interpret the question, but eventually got that correct. The key to answer is to visualize how the data gets stored in table variable. Like for the...

Interesting question Steve. I had no idea about this, except the connection of VARBINARY and FILESTREAM. Luckily was able to guess the correct answer 🙂

Easy one for the day. But I rarely use this function. Thanks for reminding the basics Mike 🙂

+1

I was little confused between msdb and master DB. Some how marked...

Easy one for the day. Thanks Bill!!

Nice question Ron!

Good start for Monday morning 🙂

Easy one for Friday morning. Thanks Kapil 🙂

I found Today's question relatively easier than yesterday. 🙂

Lucky enough to find the anomaly instead of getting into the trap of "BETWEEN (high) AND (low)" which should be otherwise 🙂

+1

Thanks for the easy one Vinay, after tricky Qotd yesterday 🙂

+1 🙁

I too rushed (over read "batch") and got the question wrong! 🙁

Good one!

I remember posting a similar Qotd last year. Here is the link: http://www.sqlservercentral.com/questions/T-SQL/93222/%5B/url%5D

Thanks for the question Vinay.

An easy one for the day. It's always good to refresh our basics 🙂