Use spatial indexes for geography distance searches, compare actual plans and reads, and inspect tessellation with built-in diagnostics.
Finding the Nearest Store With the geography Type
Find the nearest store with SQL Server geography, validate coordinate order, apply a distance radius, and inspect spatial index use.
geometry MakeValid: Repair Can Change the Geometry Type
geometry MakeValid returns a valid geometry from an invalid instance, but the result can change type. I keep the original beside the proposed repair. A validity flag alone does not describe everything that changed.
SQLAuthority News – 2 Sessions at TechInsight 2010 – June 29 – July 1, 2010
I presented two sessions at TechInsight 2010 in Kuala Lumpur, Malaysia, from June 29 to July 1, 2010. The best part of the trip was the people and their response.
Spatial Data Types for Beginners
Spatial data types in SQL Server use geometry for planes and geography for Earth; points, polygons, and indexes start with valid coordinates.
Fixing Invalid Geography Polygons and Ring Orientation
Diagnose invalid geography polygons with STIsValid and IsValidDetailed, repair with MakeValid, and check ring orientation and EnvelopeAngle.
geometry STIsValid: Parsed Shapes Still Need a Validity Check
geometry STIsValid checks whether a spatial instance satisfies the validity rules for its geometry type. I use two parsed lines to separate those questions. Successful construction alone does not establish that a shape is valid.