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 […]

(1)

You rated this post out of 5. Change rating

2006-05-18 (first published: )

700 reads

Blogs

Claude Desktop

By

Claude is more than a chat window. The desktop experience includes structured workspaces, generated...

PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate

By

A sequential scan is not always a problem — PostgreSQL's planner often chooses one...

Giving AI Agents Visibility Into SQL Server with MCP

By

I’ve been thinking a lot lately about what it actually takes to make an...

Read the latest Blogs

Forums

Running script without having permission to Function

By Reh23

Good Morning. I have a T-SQL Script which has been developed to execute a...

Stop Prompting Your AI Agent. Give It a Playbook.

By Kumar Abhishek

Comments posted to this topic are about the item Stop Prompting Your AI Agent....

Finish the quote

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finish the quote

Visit the forum

Question of the Day

Finish the quote

Finish this quote (for a fun Memorial Day question):

Do not try and bend the spoon. That's impossible. ...

See possible answers