Scott Coleman


Technical Article

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)

You rated this post out of 5. Change rating

2006-05-18 (first published: )

672 reads

Blogs

Why use XACT_ABORT?

By

This came up one day at my work when a developer was using it....

Using AI for Data Conversion

By

I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...

Advice I Like: Tipping

By

When in doubt, overtip – from Excellent Advice for Living This is close to...

Read the latest Blogs

Forums

Two Events, Two Worlds: A Week in the Life of a Technologist

By dbakevlar

Comments posted to this topic are about the item Two Events, Two Worlds: A...

Installing SQL Instance on a Clustered Virtual Disk

By bokswager

Hi Everyone, I have a question, I am trying to setup a Lab environment...

Upgrades to SQL Server 2022

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Upgrades to SQL Server 2022

Visit the forum

Question of the Day

Upgrades to SQL Server 2022

What is the earliest version from which you can directly upgrade to SQL Server 2022?

See possible answers