Hi Anthony,

The list of postcodes and their lat/long I got from http://www.freemaptools.com/download-uk-postcode-lat-lng.htm

The shp files I got from http://www.diva-gis.org/

I have now used Shape2SQL to convert the shp...

Thanks for the feedback.

I have to prove/test that SQL is not the issue before I can go to the Hyper-V team, as the application on the server feels sluggish at...

The results are just in the SSMS query window and I am RDP'd directly onto the server, this is to remove the main application as the cause of the performance...

Resolved

The network guys had added a rule and some reports' excel files being generated were treated as known vulnerabilities and blocked.

Sorry 🙁

We did a create index with drop existing for each table and a SSMS rebuild index and update statistics with full scan

None of these helped with this specific issue...

Thanks for all the pointers.

We found in the BIOS the power saving setting, so now CPU-Z is set to 2100 Mhz instead of 800

However the query was still marginally faster...

I agree there should be, but there isn't 🙁

I have attached the screen shot of it, in case that helps.

The specification line shows AMD Opteron(tm) Processor 6172

The Core Speed line shows 800.0MHz

Looking at the page

http://products.amd.com/(X(1)S(s4bgc3qbiulmcg45dgtdbjyu))/pages/opteroncpudetail.aspx?id=644&AspxAutoDetectCookieSupport=1

If I understand it correctly, we should get 2,100MHz

I've got the local guy looking at it now.

running the cpu-z tool i can see that the server is as AMD Opteron 6172 and the core speed is 800 Mhz

The...

I raised this with Microsoft and they have confirmed it is bug so will add the reosolution to the next CU.

The db is left in 2005 mode

I have tried 2008 mode but it made no difference.

The collation has not changed, it is Latin1_General_CI_AS

On other servers exactly the same setting, there...

Thanks for the extra info.

The wierd thing from my viewpoint is that If I just back/restore from sql2005 to sql2008r2, then the problem exists, even if I restart SQL rebuild...

Thanks for all the replies.

This is from Navision, so is out of my control, from a SQL perspective.

All I can say is that on SQL2005 it works fine for all...

I rebuilt indexes/update stats with fullscan etc.

But, I then to test, copied the content to another table, truncated the original 700k row table, and copied 10k back and ran the...

Indeed, but as this query against the original copy of this database on server which is a much slower server (on paper) runs fine, then I know its nothing to...