Ed Katibah Is Blogging
Ed Katibah, who has a long history with IBM and Informix and is now the spatial project manager for Microsoft’s SQL Server, is blogging.
Ed Katibah, who has a long history with IBM and Informix and is now the spatial project manager for Microsoft’s SQL Server, is blogging.
Thanks for pointing out this blog. I’m just about to install the new CTP to see if it can handle buffering large polygons a bit better. Given that SQL Server 2008 is still in CTP status, will it actually make its debut in 2009?
While we are making no promises, things are on target to ship SQL Server 2008 in Q3 of 2008.
On the issue of “…buffering large polygons a bit better…”, let me know what problems you’ve been having. We are actively fixing any bugs or misbehavior we can find.
@Ed,
My problem was that when I tried to buffer a particular large, complex polygon, SQL Server would start grabbing a lot of memory (hundreds of megabytes) and I would always have to stop the SQL Server process before the buffering could complete. PostGIS seems to handle the process a lot better, buffering the polygon in a few seconds. I’m instaling the new CTP now. Once done, I’ll try the buffer again and see if I get the same result. If so, I’ll zip the shapefile that I imported into SQL Server and indicate the polygon that’s giving me problems.
@Ed
I vote to rename your blog to “Spatial Ed.” Come on, it’s too good to pass up!
@Tim,
When you are ready, let me know (ed.katibah at microsoft.com) and I’ll set up a site to drop the shapefile off.
@Abe,
I’ll consider it…
@Abe
It is as you have wished…
I emailed Ed my problem shapefile. Ed ran a buffer on the problem polygon and the process seems to be much improved. Thanks, Ed.