Posts
  • Isaac @ MSDN

    Upcoming Conferences

    • 1 Comments
    Hi Folks, I'd like to let everyone know about a few conferences that I'll be at in the near future.  First up is PDC in Los Angeles at the end of October.  After that is the PASS Community Summit in beautiful Seattle middle of November. ...
  • Isaac @ MSDN

    The Gnomonic Projection and Operations on the Globe

    • 0 Comments
    Let's talk about projections---or at least about one very special projection: the gnomonic projection . Though it may not (or may?) be completely obvious, this post is related to the series of indexing posts that trailed off some months back, but it's...
  • 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...
  • Isaac @ MSDN

    Curves on a Round Earth

    • 0 Comments
    Hi Folks, When we talk about lines on the Earth, we don't really mean straight lines: we following the surface of the Earth, and that is inherently curved.  Instead, when we talk about lines we mean great circles (or more precisely great elliptic...
  • Isaac @ MSDN

    Spatial White Paper: Mapping and Coordinate Systems

    • 1 Comments
    Hi Folks, I'm mostly recovered from a machine crash---hard drives are the bane of the computer world---and will hopefully get to do a little more blogging soon. For now, I just want to note that our first spatial white paper just went live.  This...
  • Isaac @ MSDN

    RC0 is Out: Spatial Notes

    • 3 Comments
    Hi Folks, As we continue to shut down SQL Server 2008, our first release candidate has been released . In addition, the RC0 of the Feature Pack, which includes the System CLR Types package, is available here . This package includes the spatial functionality...
  • Isaac @ MSDN

    And the Conferences Keep Coming

    • 0 Comments
    Hi Folks, As a vague part of what has become an ongoing spatial road show, I find myself in Vancouver, BC this week at the SIGMOD conference.  I don't know how many readers I have attending this event, but if there are any, please feel free to track...
  • Isaac @ MSDN

    Eye Candy of the Highest Order

    • 24 Comments
    Hi Folks, One of the most common questions about the spatial support in SQL Server is how to visualize results. To illustrate the problem, consider a query over zip code data: select id, shapegeog from zipcodes where id like '981%' The results...
  • Isaac @ MSDN

    Our Upcoming Builder API

    • 9 Comments
    Hi Folks, We have one more upcoming pre-release before we're done with SQL Server 2008, and while I've posted a few articles about the coordinate order swap, there's another exciting piece we're releasing: our builder API. Let's say you wanted to write...
  • Isaac @ MSDN

    Coming to TechEd

    • 1 Comments
    Hi Folks, I'll be at TechEd next week, so look me up if you're going to be in Orlando next week and want to chat.  Michael Rys and I will be giving an overview spatial presentation (DAT320) at 10:15 on Thursday, and I'll be showing off some development...
  • Isaac @ MSDN

    Evaluation Order

    • 5 Comments
    A common general SQL question just popped its head up in the Spatial Forum : when presented with a SQL query, in which order are the parts executed? To be concrete, consider the following table and query: T: x 0 ...
  • Isaac @ MSDN

    Edges on the Globe

    • 3 Comments
    Hi Folks, In previous posts about our new geography type, I've discussed ring orientation and too-large polygons , but there is much more information to mine. I'm going to continue here with a discussion of edges. This post may be a little dense for those...
  • Isaac @ MSDN

    Where are my Spatial Columns?

    • 3 Comments
    Hi Folks, I've been asked a few times how to find out what spatial columns are defined in a database. We don't have any special table for this, but you can easily find out by looking at the usual system views: SELECT ta.name as table_name, co.name...
  • Isaac @ MSDN

    Connect and Implicit Casts

    • 4 Comments
    Hi Folks, Perhaps it is surprising, based on the content here, that I'm not a full-time spatial head here in SQL Server land. (We leave that job to Ed .) I have, of course, been spending a lot of time on spatial, but it turns out I have other responsibilities...
  • Isaac @ MSDN

    More on the Multi-Level Grid

    • 5 Comments
    Hi Folks, In my last indexing post , I filled in most of the details about our multi-level grid index. Let me clean up a few lingering questions about our planar grid. We'll do this Q&A style: Q: What happens if I set the maximum number...
  • Isaac @ MSDN

    The Unexpected Too-Large Polygon

    • 4 Comments
    Hi Folks, I recently got contacted via email with the following problem: ... I have 2 complex polygons, representing district boundaries. The polygons look correct, but I'm getting exceptions when I try to create the type. I've attached the...
  • Isaac @ MSDN

    February CTP Optimizer Issue

    • 0 Comments
    Hi Folks, We don't call them betas, but that's basically what CTPs are: they let us suss out problems before we drop a final product on everyone. Well, we've found a regression in the February CTP spatial support that we'd like to let you know about...
  • Isaac @ MSDN

    The Upcoming Geography Coordinate Order Swap---A FAQ

    • 14 Comments
    Hi Folks, I just thought I'd take a few moments clarify the upcoming coordinate order swap for the geography type. Here's a quick FAQ on the issue: What exactly is the change? We are swapping the coordinate order for well-known text (WKT) and...
  • Isaac @ MSDN

    Let Ed tell us what's new in the February CTP

    • 0 Comments
    Hi Folks, Well, it looks like Ed finally started blogging. (I'll try not to let him take too much pressure off me and slide worse than I have.) In his first post , he reveals what new spatial functionality is available in the most recent CTP. We...
  • Isaac @ MSDN

    Basic Multi-Level Grids

    • 3 Comments
    Hi Folks, Last time , we highlighted several problems with a simple grid index. If you don't recall---and since it's been a while, that wouldn't be a surprise---you may want to review them. In this post I'll start to describe how we get around them...
  • Isaac @ MSDN

    Picking up on Indexing: Moving Beyond the Simple Grid

    • 4 Comments
    Hi Folks, Well, I never did complete my series of posts describing our indexing scheme. I guess I ought pick it up again now. We've gone through some preliminaries so far, describing why we'd like spatial index , what a simple indexing might look...
Page 2 of 3 (72 items) 123