Great question with something valuable to learn. Even though I got the question correct, I did not know that about the precedence difference between EXCEPT, UNION, and INTERSECT. ...

Great question.

Thanks,

Matt

The issue I have is: working for a small company, it's not so easy to lay hands on an unused server we can use to restore our data! Heck, even...

Great question.

Thanks,

Matt

Great question.

Matt

Honestly, this was a good question, even with the trick. Someone not versed in what BETWEEN represents might see BETWEEN '2011-01-05T00:00:00' AND '2011-01-01T00:00:00' as logically including '2011-01-03T00:00:00'

The important thing...

Great question, Paul. It is always a good thing to know what is going on under the hood.

Thanks,

Matt

Nice question. It wasn't overly difficult, but still made you think.

Thanks,

Matt

Thanks for the question.

Matt

I knew there was something out there that would invalidate...

I have security and ROI concerns over this. The security concerns stem from not having control over every piece of hardware. Granted, there are companies with this complete...

This style of question always intrigues me. Typically, you will never see a feature in a "lesser" version of SQL Server that is not also in a "greater" version...

Thanks for the question. This is a feature I have not been able to play with too much, but one that I can see some uses for.

Matt

Nice question. Thanks.

Matt

Thanks for the question.