SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Daily Denali Delight – Day 5

Code-named Denali – the next version of SQL Server is fast approaching.

And whenever CTP2 gets released you can be sure to expect some excellent new features.

Here I continue to delve into these delights, highlighting those to look out for.

Spatial Features

Not that I get to play around with the spatial element too much in my current role,  SQL Server spatial features have been greatly expanded within this Denali release.

Highlights include:-

new CircularArc subtypes, support for objects bigger than a logical hemisphere (including a new FULLGLOBE data type), new methods for the geography type, spatial index improvements, Nearest Neighbor Query Plan, and support for persisted computes columns. Plus the inclusion of  the CollectionAggregate, ConvexHullAggregate, EnvelopeAggregate, and UnionAggregate spatial aggregates.

To get more detail on these features and more, the New Spatial Features Whitepaper can be downloaded from Microsoft.


Posted by Steve Jones on 27 April 2011

Would be nice to see a few images of what this might mean to people.

Posted by rwb1912 on 15 May 2011

Having been involved with projects at the Counsel with building consents and permits I can see how enhanced spatial features could have helped us out here several years ago. I believe as time goes by these features will play a crucial role in some SQL related projects.

Leave a Comment

Please register or log in to leave a comment.