T-SQL distance formula with radius in miles around a central location
What is the best way to calculate the formula for distance around a center location using radius in miles? We usually use a circular radius formula, but consider using a simple square because it is faster and more efficient.
Sometimes we need to be precise, so we'll use a circle, but other times we can just use a square for a faster calculation.
source to share
We'll have to tackle this next month, so I recently spoke with this person.
Apparently the trick is to first determine the size (in kilometers or miles) of the scale at 1 degree around your center point, as this will depend on where you are in the world.
eg. Alaska is very different from somewhere near the equator, then use that to figure out how many degrees, or 10th 100th, etc. to make your box. May require a set of them if needed, depends on how accurate you are.
source to share