Spatial Data

SQL Server Spatial Indexes

  • Article

Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example, to break down an indexed space into a grid hierarchy by using a technique called tessellation. This is a rules-based system that, when you compare a shape to an index, works out how many cells in the the grid hierarchy are touched by that shape , and how deep down the grid hierarchy to search. There is powerful magic in Spatial Indexes as Surenda and Roy explain.

2015-04-15

7,242 reads

Introduction to SQL Server Spatial Data

  • Article

More and more applications require the handling of geospatial data. It is easy to store spatial data, but it takes rather more thought to retrieve and manipulate it. Tasks like searching neighborhoods, and calculating distances between points is often required from databases. But how do you start? Roy and Surenda take you through the basics.

2015-04-06

9,426 reads

Blogs

Updated Pluralsight Course – Managing the Kubernetes API Server and Pods

By

My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...

Daily Coping 11 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

What do you do when technology changes? : T-SQL Tuesday #138

By

Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...

Read the latest Blogs

Forums

high CPU

By sqlguru

CPU Usage was running very high than normal. Identified the top query, so removing...

SSRS Report Subscription Fails (Failure sending mail) due to column contents

By street9009

I've had this problem rear its head before but not in some time. There's...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers