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

COVID-19, a wake-up call

By

COVID-19 is the only pandemic I’ve seen in my whole life. It gave me...

ASF 030: Benni De Jagere interview

By

Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...

Going Dark in SSMS

By

I haven’t been a big fan of dark mode in many tools, but I’ve...

Read the latest Blogs

Forums

How to make join to teams display without join all teams ?

By ahmed_elbarbary.2010

problem How to make left join to only teams displayed  dynamically depend on fields...

sql server memory buffer cache building up question

By sqlguy80

question for DB Gurus when sql server is restarted, it will be slow at...

Query Optimization Level

By Grant Fritchey

Comments posted to this topic are about the item Query Optimization Level

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

SQLCMD Output

See possible answers