Scott Coleman

Calculate distance between two points

The calculation of distance between two points using standard spherical geometry can be inaccurate for short distances (ten miles or less) because the sine function of very small angles approaches zero. The haversine approach (http://en.wikipedia.org/wiki/Haversine_formula) turns this around, so it is very accurate at small distances but has larger errors (about ten miles) for points […]

4 (1)

2006-05-18 (first published: )

519 reads

Blogs

Life Support 2008 – Audit Logons

By

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

By

This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs

Forums

full text search

By Sailor

Trying to understand why when I search for numerics in full text, contains does...

New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012?

By Andy sql

MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new...

SSIS Package/Agent Job Not Failing!!!

By tim.ffitch 25252

I have a package running in SQL 2016 using Project Deployment. One of the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers