puja63 (11/18/2010)

I'm not an expert in SQL. I was also under the impression that Cursors are a big NO and hence should be avoided at all costs. I'm only saying...

Indexes are data duplication as well. Do you avoid them as well?

In both cases,...

Carlo Romagnano (11/18/2010)

Hugo Kornelis (11/17/2010)Without the reversal, the question would have been a solid test of whether people know about the dangers of using CASE in ORDER BY, and thus...

Good question; many people would expect this to work. (As I did, the first time I ran into this. And the second, third, ... - I answered correctly but only...

Hi Mister Magoo,

In addition to the points raised by Paul, here is one more.

Older versions of SQL Server (prior to SQL Server 2005) allowed you to create "ordered views". This...

Cliff Jones (11/17/2010)

UMG Developer (11/17/2010)

But what...

Please explain.

Or, if we are just throwing terms without any backing, I'll...

A disappointing article on an underrated feature.

Yes, indexed views can result in a huge savings on query execution times.

But indexed views also have their price. Someone who does not know...

I really liked the subject matter of the question - mixing data types in an ORDER BY is an error I see being made lots of times, and it's not...

I don't like having multiple triggers for the same operation, so I prefer at most one for each action (insert, update, delete). I rarely write triggers for more than one...

Good question. I answered wrong; I thought all statements were cached.

Hardik, do you have any references where I can read more about this?

A good question, that made me think twice.

Two minor issues though.

1. The negation in the question is a needless extra complication. It would have been better to ask which of...

I interpreted Sanjay's post to refer to the double meaning of 1 - either an ordinal column position when used in ORDER BY, or an integer value when used somewhere...

Oleg Netchaev (11/9/2010)

Simply due to sanity reasons.

(...)

While this is true that in newer versions of Oracle...

Nice, easy question.

I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this...