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)

2006-05-18 (first published: )

646 reads

Blogs

Converting Types in C#

By

I am not a great software developer. I’m OK, and I do know how...

Daily Coping 22 Mar 2023

By

Today’s coping tip is to appreciate your hands and all the things they do...

FIRST Robotics Competition 2023 - World Championships!

By

On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...

Read the latest Blogs

Forums

DOP_FEEDBACK in SQL MI

By cooldude001

I'm changing the DB Compatibility mode to 2022 in SQL Managed Instance. below features...

index analysis help

By vsamantha35

Hi All, We see some tables in Prod are having 20-30 indexes and we...

Accessing SSAS Cubes on Mac

By tmmutsetse

Hi, Can someone please let me know if it will be possible to create...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers