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: )

663 reads

Blogs

Elastic Jobs for Azure SQL DB

By

I know if you are a SQL Server DBA using Azure SQL DB, you’ve...

Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module

By

Full documentation on the Undercover Catalogue can be found HERE It’s been a while...

Familiar Sights

By

Yesterday was a long day in London. I arrived late in the am, and...

Read the latest Blogs

Forums

Find the problematic Sql Query Caused Application Crash

By RCRock

Hi, Is there anyway I can find out the sql script ran on a...

Full vs. Incremental Loads – Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Full vs. Incremental Loads –...

Restoring the Resource Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Restoring the Resource Database

Visit the forum

Question of the Day

Restoring the Resource Database

How can I restore a version of the Resource Database in SQL Server 2022?

See possible answers