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.

(2)

You rated this post out of 5. Change rating

2025-03-04 (first published: )

2,669 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 […]

(8)

You rated this post out of 5. Change rating

2020-02-13

5,994 reads

Blogs

T-SQL Tuesday #193 - Notes to Self

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

T-SQL Tuesday #193 – Notes to my past self and from my future self

By

It has been a while since my last T-SQL Tuesday blog. When I saw...

T-SQL Tuesday #193 – Notes to past and future me

By

The last T-SQL Tuesday of the year is hosted by my good friend Mike...

Read the latest Blogs

Forums

What is the PRODUCT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is the PRODUCT

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...

Visit the forum

Question of the Day

What is the PRODUCT

In SQL Server 2025, what does this return?

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

See possible answers