August, 2008

Posts
  • Isaac @ MSDN

    Is my spatial index being used?

    • 10 Comments
    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...
  • Isaac @ MSDN

    Connecting With Connect

    • 2 Comments
    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...
  • Isaac @ MSDN

    New Goodies in SQL Spatial Tools

    • 1 Comments
    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...
  • Isaac @ MSDN

    The Imprecise Nature of Geometry

    • 6 Comments
    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...
  • Isaac @ MSDN

    CodePlex: SQL Server Spatial Tools

    • 4 Comments
    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...
Page 1 of 1 (5 items)