Spatial Data

Standardize data storage for geography spatial data type in SQL Server

  • Article

Geography is one of the spatial data types introduced in SQL Server 2008. One of the characteristic of the geography data type is that it can accommodate any supported geometry based on any supported spatial reference system in the same field. So if the data that is stored in a column of geography data type is not standardized, it can be a very tedious and resource intensive task to figure out the geometry and spatial reference system associated with each value. To deal with this issue, we need to standardize the data stored in a field of that has the geography data type and in this tip we will look at how to deal with this issue.

2010-10-04

2,316 reads

SQL Server 2008 Spatial Index Performance

  • Article

The institution I work with has decided to migrate their database system to SQL Server 2008. One of the applications uses geospatial data, which consists of millions of rows. I understand that their are indexes that can be used for geospatial data, but have not worked with them. What's the scoop on them?

2010-04-08

4,056 reads

Blogs

What you need to know About Azure SQL backup

By

Most of DBA are coming from On-premise Database Servers they know very well How...

Social: Respecting Names

By

This is a non-technical post, and my opinion. If you don’t want to read...

Proud to present at this year’s VMworld 2020 conference

By

I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...

Read the latest Blogs

Forums

SSIS DB migration from one server to other server.

By Srinivas Sista

Summary: We had migrated SSISDB from SQL Server version 11.0.6260 to SQL Server version...

Permission to view SQL jobs in SQL Server 2017

By Srinivas Sista

Hi, I'm using SQL Server 2017, I need to give developers only to view...

Offline Filegroups

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Offline Filegroups

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers