Nice easy Question, but again it makes me think...
Which of these the the better performs better, and what factors determine that?
SELECT DISTINCT *
FROM (VALUES (1),...

DITTO...  First look, Too easy, then I realized what was missing...
Excellent Question..

Good Question.  First instinct was right, but it made me review.

Hi,
I have much more to learn than to teach, but I have a habit of using a CTE when I need to JOIN or WHERE on a function.

OOpppss.  Read this >>https://docs.microsoft.com/en-us/sql/relational-databases/automatic-tuning/automatic-tuning?view=sql-server-2017
and failed to recognize the last sentence .....

Discovered this just a few weeks back, after installing 2017 for training as I am attempting to learn Python.
I never did discover why though, can anyone shed light ??

Very interesting and I think this would be the same as 
(select a from tbl1 WHERE a NOT IN (select a from tbl2)) union (select a from tbl2 WHERE a...

This must be a MS Question 🙂  One of those splitting hairs (in my opinion)
The difference between Highest value and Last value - REALLY  ?
Thanks for making be...

Good question.
My Question is why?  Doesn't the Procedure run within a separate session, and aren't #temp table session specific ??

WOW !!
Awesome question and great explanation, BUT 🙂
"3. CAST(... AS VARCHAR) converts the binary value, byte-by-byte into a new string. If you select this value in SQL Server,...