Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Designing spatial data storage methods


The support of SQL CLR allows applications to manage rich user-defined data such as mathematical or geographical based data. SQL Server 2008 enables the native support of .NET CLR data types by providing two data types: GEOMETRY and GEOGRAPHY.

Managing a spatial type of data will require high-performance and high-end hardware with a massive data storage solution. However, SQL Server features on these two new data types have enabled the applications to support various methods that will allow for creation, comparison, analysis, and spatial data retrieval. In this recipe, we will go through the process of designing spatial data storage methods using SQL Server 2008 R2.

Note

For more on OGC and the WKT/WKB/GML XML transport formats, review http://www.opengeospatial.org/standards/sfa.

Getting ready

Every edition of SQL Server 2008 R2 supports the spatial data services, and the only exception for SQL Express edition is, there is no graphical interface to view...