SQL SERVER – What is Spatial Database? – Developing with SQL Server Sp...

SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing

4/14/2010

What is Spatial Database? A spatial database is a database that is optimized to store and query data related to objects in space, including points, lines and polygonsWhile typical databases can understand various numeric and character types of data, additional functionality needs to be added for databases to process spatial data types.

(Source: Wikipedia) Today [...]

Full story: Journey to SQL Authority with Pinal Dave

Similar articles

Journey to SQL Authority with Pinal Dave

SQL SERVER – World Shapefile Download and Upload to Database – Spatial Database During my recent, training I was asked by a student if I know a place where he can download spatial files for all the countries around the world, as well as if there is a way to upload shape files to ...

DotNetShoutout - Latest published stories

SQL SERVER – World Shapefile Download and Upload to Database – Spatial Database « Journey to SQL Authority with Pinal Dave During my recent, training I was asked by a student if I know a place where he can download spatial files for all the countries around the world, as well as if there is a way to upload shape files to ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Poll Result – What is Your Favorite Database? I previously posted a Poll about What is Your Favorite Database? I got great response from users. In fact, I received some of the best poll-related comments on this blog and they are worth reading. L...

Journey to SQL Authority with Pinal Dave

SQL SERVER - Poll Result - What is Your Favorite Database? I previously posted a Poll about What is Your Favorite Database? I got great response from users. In fact, I received some of the best poll-related comments on this blog and they are worth reading. L...

Journey to SQL Authority with Pinal Dave

SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server I was recently called to attend the Query Tuning Project. I had a very interesting experience in this event. I would like to share to you what actually happened. Note: If you are just going to say tha...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Importance of Database Schemas in SQL Server Beginning with SQL Server 2005, Microsoft introduced the concept of database schemas. A schema is now an independent entity- a container of objects distinct from the user who created those objects. Pr...

Comments on this article

Add your comment

Report

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use th...

Journey to SQL Authority with Pinal Dave

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion Some confusion never go away. Here is the one of the ancient one. Precision of the SmallDateTime is the one concept/confusion I...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Renaming Index – Index Naming Conventions If you are regular reader of this blog, you must be aware of that there are two kinds of blog posts 1) I share what I learn rece...

Journey to SQL Authority with Pinal Dave

SQL SERVER – New Look for CodePlexProject – Hosting for Open Source Software Codeplex is my favorite site. CodePlex is Microsoft’s free open source project hosting site. You can create projects to sh...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST Note: I have used SQL Server 2012 for this small fun experiment. Here is what we are going to do. We will run the script one at ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server 2012 – Guest Po Nakul Vachhrajani is a Technical Specialist and systems development professional with iGATE having a total IT experience of more...

Journey to SQL Authority with Pinal Dave

SQLAuthority News – SQL Server 2012 Upgrade Technical Guide – A Comprehensive Whitepaper – (454 pages – 9 MB) Microsoft has just released SQL Server 2012 Upgrade Technical Guide. This guide is very comprehensive and covers the subject of ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – SQL in Sixty Seconds – 5 Videos from Joes 2 Pros Series – SQL Exam Prep Series 70-433 Joes 2 Pros SQL Server Learning series is indeed fun. Joes 2 Pros series is written for beginners and who wants to build experti...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME Sometime a simple solution have even simpler solutions but we often do not practice it as we do not see value in it or find it u...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats As you know I have been writing on Columnstore Index for quite a while. Recently my friend Vinod Kumar wrote about SQL Server 2...

SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing

Similar articles

Journey to SQL Authority with Pinal Dave

DotNetShoutout - Latest published stories

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Comments on this article

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Sign In