Browse by Tags

Tagged Content List
  • Blog Post: The Database Shuffle

    Hi Folks, As I mentioned in my previous post , I recently moved from my old home in the SQL Server engine to the StreamInsight team. As I continue to ramp up here, I want to take a few posts to talk about what I was working on back in the engine: the contained database . To illustrate the problem...
  • Blog Post: Where are my Spatial Columns?

    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 as column_name FROM sys.tables ta JOIN sys.columns...
  • Blog Post: Connect and Implicit Casts

    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 as well, particularly around the broader...
  • Blog Post: More on the Multi-Level Grid

    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 of cells-per-object so small that I cannot obtain...
  • Blog Post: The Unexpected Too-Large Polygon

    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 wkt polygons to the email. These polygons are stored...
  • Blog Post: February CTP Optimizer Issue

    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. Essentially, a costing problem was introduced...
  • Blog Post: The Upcoming Geography Coordinate Order Swap---A FAQ

    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 well-known binary (WKB) formats from latitude-longitude...
  • Blog Post: Basic Multi-Level Grids

    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. In SQL Server, we don't use a simple grid like...
  • Blog Post: One Type, Two Types...

    This is a little bit less of an introductory post than the last one , but there was quite a bit of discussion about our decision to split our spatial types in two---one for our planar ("flat-Earth") model and one for our ellipsoidal ("round-Earth") model---so I thought I'd address it. To be honest, this...
  • Blog Post: SQL Server Spatial Support: An Introduction

    I’ve been pretty quiet around here, and at least part of the reason is that we’ve been pretty tight-lipped about what we’ve been up to. We’ve now gone public—we’re providing support for geospatial data in our next version of SQL Server, codenamed Katmai. The Virtual Earth folks mentioned this in their...
Page 1 of 1 (10 items)