Welcome to Romanian SQL Server User Group Sign in | Join | Help

Browse by Tags

All Tags » SQL Server Spatial   (RSS)

New Wiki posting: SQL Server 2012 spatial features available in SQL Azure now!

A short while ago, I wrote a blog entry about SQL Server 2012 features that are currently available in SQL Azure. In that post, I mentioned that Ed Katibah would publish an article detailing the current state of the SQL Server 2012 spatial features in Read More...
Posted 26 octombrie 2011 02:23 from Bob Beauchemin's Blog | (Comments Off)

Spatial index compression in SQL Server Denali

Since SQL Server Denali adds support for index compression of spatial indexes, using the same options as data and index compression in SQL Server 2008 and above. As opposed to what I expected at first (because spatial indexes consist of only a few small Read More...
Posted 30 septembrie 2011 11:11 from Bob Beauchemin's Blog | (Comments Off)

A quick set of SQLCLR spatial decomposition functions

Saw a request on the SQL Server spatial forum this morning for routines that would decompose a geography type to a set of Lat/Longs. A while ago, I was experiemnting with spatial decomposition, and happened to cruft up a couple of SQLCLR table-valued Read More...
Posted 10 septembrie 2011 07:35 from Bob Beauchemin's Blog | (Comments Off)

SQL Azure "version 11" arrives on my server

I've been trying this out every day or so since I'd heard about the update (originally named the July 2011 Service Release ), but I'd forgotten about it for about a week. So I don't exactly know when this happened on my SQL Azure server. Read More...
Posted 5 septembrie 2011 21:44 from Bob Beauchemin's Blog | (Comments Off)

Interesting SQL Azure change with next SR

In looking at the what's new for SQL Azure (May 2011) page, I came across the following: "Upcoming Increased Precision of Spatial Types: For the next major service release, some intrinsic functions will change and SQL Azure will support increased Read More...
Posted 1 iunie 2011 10:01 from Bob Beauchemin's Blog | (Comments Off)

Visualizing the new Denali curve spatial types

I'd been fretting over the lack of a true visualizer for the new circularstring and compoundcurve spatial types in SQL Server Denali. I'd installed SSMS from SQL Server 2008 R2, and although it works just fine for Denali spatial types (even though Read More...
Posted 7 februarie 2011 10:37 from Bob Beauchemin's Blog | (Comments Off)

Using the Denali spatial aggregates on the client

One of the interesting spatial features in SQL Server Denali is the inclusion of spatial aggregates, namely CollectionAggregate, ConvexHullAggregate, EnvelopeAggregate, and UnionAggregate. Here's an example of unioning two squares together to make Read More...
Posted 25 ianuarie 2011 00:52 from Bob Beauchemin's Blog | (Comments Off)

The nearest neighbor optimization in SQL Server Denali

The nearest neighbor query is one of the most common queries against spatial data. How many people haven't gone to a mapping app, typed in their current location and asked for the 10 nearest [your favorite thing goes here]? The obvious way to phrase Read More...
Posted 3 ianuarie 2011 10:24 from Bob Beauchemin's Blog | (Comments Off)

The "other fullglobe feature" in SQL Server Denali

Now about that "other" feature that could be called fullglobe in Denali that I mentioned . I don't know which feature will retain the moniker or whether they both will...that's why I'm not in marketing. Here's the deal... the Read More...
Posted 29 decembrie 2010 10:38 from Bob Beauchemin's Blog | (Comments Off)

New curve types in SQL Server Denali are now in OGC spec

Once upon a time , I wrote a blog entry about CircularString, CompoundCurve, and CurvePolygon (the new geometric types supported in Denali). And mentioned that they came from ISO-ANSI SQL/MM and weren't in the OGC spec. Well, lo and behold, while Read More...
Posted 29 decembrie 2010 09:14 from Bob Beauchemin's Blog | (Comments Off)

Measuring the earth with SQL Server Denali

So what's the area of the earth? Well...depends on who's measurement you want to use. There an interesting SQL Server Denali spatial feature known as fullglobe. Actually there's two features with that name, more later; I was using the FULLGLOBE Read More...
Posted 29 decembrie 2010 06:29 from Bob Beauchemin's Blog | (Comments Off)

SQL Server Denali - the new autogrid spatial index

I've been trying out the new Denali "AUTO_GRID" spatial index (that is ...USING GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID in the CREATE SPATIAL INDEX DDL) on some of my old spatial performance use cases. It's worth repeating (from Ed's Read More...
Posted 23 decembrie 2010 13:17 from Bob Beauchemin's Blog | (Comments Off)

Loading spatial data into SQL Server - SAFE Software Webinar

Safe Software , the premier spatial data transformation and loading vendor for SQL Server, has long been known for it flagship FME Desktop and FME Server products (that include a spatial workbench for transformation and loading, support a ton of spatial Read More...
Posted 7 decembrie 2010 09:47 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

New spatial query hint when using indexing

OK, last one for the evening, its getting late in Berlin. And BTW, we might have some Denali goodness here at TechEd. Search for "futures", perhaps. There a new hint for spatial queries in Denali CTP1, namely, SPATIAL_WINDOW_MAX_CELLS. This Read More...
Posted 9 noiembrie 2010 12:01 from Bob Beauchemin's Blog | (Comments Off)

Repost/Revision Updated serialization formats for SQL Server spatial types

SQL Server Denali CTP1 was released today. I don’t want to be the fiftieth person to post the link to the download; reference Ed's blog posting for the location. This is a repost (with some corrections now that the CTP is actually out) of a Read More...
Posted 9 noiembrie 2010 10:49 from Bob Beauchemin's Blog | (Comments Off)
Filed under:
More Posts Next page »