Spatial

SQLServerCentral Article

Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions

  • Article

Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especially valuable for property and casualty (P&C) insurers, who need to assess their insured property exposure when severe weather events such as tornadoes occur.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

You rated this post out of 5. Change rating

2025-03-04 (first published: )

2,461 reads

SQLServerCentral Article

Collections

  • Article

Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of integers? They are lists or arrays consisting of integers. The number of […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.13 (8)

You rated this post out of 5. Change rating

2020-02-13

5,978 reads

Blogs

Who are you? Building an identity map.

By

I admit that until I read the article, Who are you as a Leader?,...

Call a Fabric REST API from Azure Data Factory

By

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...

Distributed Availability Group Dashboard

By

The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...

Read the latest Blogs

Forums

Create Raw Zone Tables using Generative AI: Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Create Raw Zone Tables using...

Database DevOps Metrics

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database DevOps Metrics

Replacing a NULL II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Replacing a NULL II

Visit the forum

Question of the Day

Replacing a NULL II

What is returned from this code in SQL Server 2022? 

DECLARE
  @value INT = NULL
, @value2 VARCHAR(20) = NULL;
SELECT COALESCE (@value, @value2, 100.5) AS Result;
GO

See possible answers

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy