Thanks, I will ad STIntersects to my list of things to test out. And yeah, BETWEEN on integer comparison absolutely kills performance, it was the reason I started doing...

mickyT (11/3/2013)

Having another look at your query, the points you are creating for the fact table are in a straight line on a zero y coordinate, unless you are creating...

mickyT (11/3/2013)

Hugo Kornelis (11/3/2013)

* Are you running on SQL Server 2008? If so, check SELECT @@VERSION to see what, if any, service pack you have installed. If you are on...

I'm hesitant to since this is my company's data. Any advice to offer without me having to upload specific details of the underlying structure? Things to look out...

OK so the query looks as follows:

SELECT

<fact table attributes>

,Tr.Country

,tr.city

,tr.Region

,Tr.dmacode

FROM #fact_table ip

LEFT JOIN GEO2IP tr ON geo_range.STWithin(geometry::STGeomFromText('POINT('+CONVERT(varchar(20),ip.IP_Converted)+' 0)',0)) = 1

Here's the relatively simple DEP:

I admit DEP analysis is...