Lab Sql

I want to find the shortest distance between two SqlGeography polygon. I know there is a method Sho… Read more Finding Shortest Distance Between Two Polygons(sqlgeography C# )

I'm trying to create a circle in a SQL Server based on a midpoint and a radius. This seems … Read more Sql Server Circle

I'm trying to populate my DB with geographical places of my country. One of my tables have 4 fi… Read more Mysql Insert/update On Point Column

I have written a stored procedure that, yesterday, typically completed in under a second. Today, it… Read more Sql Server - Stored Procedure Suddenly Become Slow

Is there a way to subtract a geometry from another? A kind of reverse STUnion.. The problem I am h… Read more Subtracting A Sql Server Geometry From Another

SQL Spatial Features: SQL geometry Point, Linestring working well but the Circular string is not wo… Read more Sql-server 2008 R2 Geospatial Query Error For Circular String

I have 2 tables one with points as geographies and other with polygons as geographies. I am able to… Read more Sql Spatial Join

When I apply STBuffer(1) to a Point in SQL Server Spatial, they show up as an oblong circle, instea… Read more Why Are My Buffered Points Oblong And Not Circle In Sql Server Management Studio - Spatial Results