I've seen a problem commonly phrased something like: I have X million records in a spatial table, and have created a spatial index, yet a simple select query takes me Y hours to complete. Ouch! If the problem is this extreme, the solution is usually pretty...

Hi Folks, This post is motivated by some recent discussion I've seen in the various tubes .  I don't mean to be critical of any of what's been said.  Rather I want to shine a little light on our thinking, processes, and tools.  We have...

Hi Folks, Marko Tintor, one of our spatial developers, just uploaded a bunch of new functionality to the SQL Spatial Tools project on CodePlex.  I've updated the list of contents on CodePlex, but Marko lays this out the addition quite simply himself...

Hi Folks, Let's kick this off with what may be a surprising result.  What should this code return? declare @g geometry = 'LINESTRING (0 0, 1 3)' declare @h geometry = 'LINESTRING (0 3, 2 0)' declare @i geometry = @g.STIntersection(@h).ToString...

Hi Folks, I've just published a new project on CodePlex: SQL Server Spatial Tools .  The core idea is that instead of pushing up more samples showing how to extend our spatial functionality in text , we can put them in a more usable form.  Beyond...