Same way it always does, Remi... someone will make a justification something like "Well Jeff, it depends..."   Six months later, they'll be scrambling to...

Like I said, fishing is good in the performance world... didn't even have to search for it... was the next item for me on "Active Threads"...

For all of those that think...

Oh my... Steve, you sure do know how to press the buttons   You basically brought the guns to bear on two of my...

Uh-huh... they need two special controls... one is a "Run SQL Faster" button and the other is a slide control to adjust the knowledge level of the developers writing code...

Yeah, huh?  Still can't get used to that...

Thanks guys.

"20 minutes through Toad" doesn't use linked servers... it uses direct connections.  Are you trying to join Oracle tables though the linked servers?  That's probably not going to work so...

What would be more interest is to find out why you're storing this data in a table to begin with... distance calculations are not that difficult even when based on Lat/Lon.

Heh!  Yeah, I'd like to see that, as well

You didn't say how big TempDB had gotten... how big is it?

So... no feedback on my questions, am?

Thanks for the feedback, Gova.

Michael's suggestion of using his very fast date generator function would do nicely.

Strange to have a DBA that won't allow adding helper tables to a DB...

Thanks, Edogg... appreciate the effort...

... but why in the hell won't the OP tell me   All take, no give... I've asked Tracey twice, now....

OK... Thanks for the feedback and understood...

I see a couple of folks have already given you a solution but I am curious about the source of data (always looking for...

I hate it when fish smells like rotten eggs