I'm not familiar with FIRST_VALUE. But I guessed it meant the first value that you run across. Since the data was partitioned by planer and ordered by date (for that...

Add me to the list of those who have never used this.

My experience has been that projects are late because of unrealistic deadlines up front. To take a slower approach would only make them later. To be realistic about how long...

I don't work with these much but my research must be flawed. I can't seem to verify that all three answers are true, just the 8000 limit.

Good reminder about the ALL part of UNION. I've got myself caught up when I wanted all rows and forgot to use the ALL. My duplicates, which I wanted, disappeared....

Gary Varga (10/23/2014)

Not sure that I like the thought of being...

CAS grants it, HPA denies it.

Just have to specify a table and index.

Pretty straight forward. RADIANS(DegreeValue)

Easy one. ISO 8601 uses the 24-hour clock system.

I figured it had to be the oldest since the LSN always get larger with each successive entry.

Wow, the power of a semicolon. I don't use them in my sql. But I don't create stand alone selects without a FROM. But it gives me something to watch...

New to me too but sounds interesting. I think I'll look into it more. Thanks.

I guess I'm ignorant because I don't get the joke.

That is so true about burn out. I've put in plenty of long hours, even all-nighters. But it can't go on forever. I've had managers who thought otherwise.