Tag Archives: Denali

SQL Server 2012 – What’s New for Spatial?

So Microsoft launched SQL Server 2012 today, and you can download the SQL 2012 Express edition right now from http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx No doubt there will be lots of people writing blog articles about the various new features – AlwaysOn, Column Store … Continue reading

Posted in Spatial, SQL Server | Tagged , , , , | 7 Comments

Can’t Cast from SqlGeometry to SqlGeometry and Other Strange Version Conflicts with SQL Server Denali Microsoft.SqlServer.Types

I came across a curious error earlier today when attempting to use a SqlDataReader to read a column of geometry data from a SQL Server table: System.InvalidCastException: Unable to cast object of type ‘Microsoft.SqlServer.Types.SqlGeometry’ to type ‘Microsoft.SqlServer.Types.SqlGeometry’ SqlGeometry to SqlGeometry… … Continue reading

Posted in Spatial, SQL Server | Tagged , | 1 Comment

sp_help_spatial_geography_histogram and Indexing geography data in SQL Server Denali

Working with spatial data involves many dark arts, and performance tuning spatial indexes is perhaps the blackest of all of them. Although there are only a few parameters to configure: GRIDS, CELLS_PER_OBJECT, and BOUNDING_BOX, the number of different index combinations … Continue reading

Posted in SQL Server | Tagged , , | Leave a comment

Determining the Geographic Extent of Spatial Features in a SQL Server Table

I’ve been using the SQL Server Denali CTP(s) for just over 6 months now. As a result, I’ve become accustomed to some of the new features and forget that they aren’t generally available in production environments yet… it always comes … Continue reading

Posted in SQL Server | Tagged , , | 6 Comments