This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A pale stone courtyard path is bordered by white stones, with loose slate, terracotta bricks and a shell beside the edge.

geometry STIntersection: Return the Shared Shape

April 30, 2009
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STIntersection returns the shared shape rather than only an intersection flag. I inspect its type and emptiness alongside its area. A shared edge has zero area but still contains points.

Read More
Gouache painting: on a smith's slate bench, one long iron bar lies between two stone blocks

geometry STEquals: Equal Shapes Can Have Different Text

March 20, 2009
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STEquals compares the represented point set, which can stay the same when its text representation changes. I separate that question from byte-for-byte text identity. Reversing a line does not necessarily change the places it occupies.

Read More
SQL SERVER - Spatial Database Definition and Research Documents

SQL SERVER – Spatial Database Definition and Research Documents

June 9, 2007
Pinal Dave
SQL Tips and Tricks
Spatial Database

What is a spatial database? It is about lines, points, polygons and their features, and SQL Server was not one. My simple answer plus research documents.

Read More
Previous 1 … 3 4 5 6
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com