Why am I unsurprised that you would have studied Sindarin, Gail?

I had a go at memorizing Tolkien's poetry once. (Which I concede is not brilliant, but then I...

Those runes look more like Dwarvish, Paul:

Barak Khazad!! Khazad ai-menu!!

Loosely translated: Keyboards of the the DBAs!! The DBAs are upon you!!

Note: ...

I couldn't agree more.

Did somebody order a babelfish?

Adrian, I have nothing against those two approaches you listed. At a glance, they appear perfectly workable. Please understand that no techniques were deliberately excluded, other...

No problem. Declare the variable as geometry and use your x-y values. The polygon can have irregular sides and the area calculation should still work.

You may not.

Hrrrrrrm.....

Thanks, Gus. 🙂

There are several approaches to solving the "get all columns of only one row from a group" problem.

Three different approaches are described here[/url].

But for a small number of rows in...

Okay... can someone explain to me why a DBA might choose to disable statistics on tempDB?

Good luck. If that situation doesn't change, then every time you use a temp table you are going to have to use hints. Not good...

No problem, Ryan. We're not all DBA's. I'm a developer too.

I'm kind of curious though. Why would anyone disable statistics on tempDB?...

Jason, I hadn't planned on a sequel. No pun intended. Right now I have another writing commitment to honor before I can do another article. ...

Ryan, could you possibly post up the code and an execution plan so we can see what is going on?