Always happy to help, Flo. 🙂

By the way, Mark is right. NULLS shouldn't count. My code above would give false results if null values...

Flo: An average is reached by summing the values and dividing by the number of values. A median is the value at the middle of an...

Thank you, ma'am. 🙂

(I always make it a point to be polite to ladies... especially martial artists who can also humiliate me technically. It's a southern...

I have to ask (somewhat fearfully) how did Gail get to be Gila Monster?

G: Do you prioritize what needs to be done first, or just take things on a FIFO basis?

I actually found ruthless to be a very appropriate term. Every day another thousand potential distractions are created to try to grab our attention and vie for a...

Thanks, Andrew 🙂

7. The clustered index should always be on the Primary Key.

You mean like SELECT... INTO.... ??

The truly sad thing about this one is that it...

How about?

1. Everyone knows that databases don't scale.

2. Everyone knows that SQL Server is slow.

3. We are going...

Is this it?

I don't think you need to worry, Jim. I've never heard your name mentioned by anyone in any context underlying the start of this thread. ;-)...

Lynn deserves some kind of award for his missionary work in Darkest Procedural Land during the Rant.

I DID sort of limber up my throwing arm while pondering my reply. 😀

He is a trophy. Stuff him and mount him on the wall. You could tell from his first...