I have to agree with Milzs. I had to flip a coin before answering this question.

Redundant and duplicative are nearly synonyms without any other context.

IMHO, to be fair, both...

Also, it is never a good idea to make a design decision like this (allow only deterministic functions and assume that all similar invocations are the same) purely for performance....

There are three knowledge base articles that deal with this assumption that the SQL processor makes. One of these indicates that the problem is an unfixed bug but maybe...

I don't understand what you mean by "UDF OUTPUT" here, but I'm interested in your idea.

Function calls return different data depending on the input parameters. SQL doesn't recognize that...

So why did our recorded answers change and now show as incorrect?

Razvan,

I really appreciate your bringing this to me attention. Thanks.

In one other case, I have found that if I place a call and explain it in a reasonable way, including...

My answer has been changed for me too and I have it wrong AGAIN!

Yes. The 'false' flag should not be included to give the stated result.

However, Books Online is not clearly worded and could cause confusion. I had to read it several...

TextPad has good highlighting capabilities for SQL code. There is a free version with annoyances or you can pay for a licensed copy. I liked it so much...

A valuable way of looking at this is that any valid column expression is valid in the ORDER BY or GROUP BY clause. That can be very useful knowledge.

SQL...

Is that parameter spelled correctly? There is nearly identical code on MSDN with a different spelling. What is the correct spelling of the parameter? Is the indicated...

The automatically generated code and most examples use things like TextBox1. So it is like expanded HN with the class name first and then the specific variable name as...

I agree strongly with the statements here. Modern IDEs are starting to support SQL code and can assist with technical information while developing and debugging, reinforcing the idea that...

The main problem with encapsulating such logic within a function is that the query processing might not be able to optimize based on indexes and relationships that it "can't see"....

Yes. I suppose since you are probably a native speaker of english, you had no problem in understanding the question. For non-native speakers, it is difficult to interpret...