SQL 2022 introduced the function generate_series which permits us to solve problems for which we previously had to use a table of numbers (also known as a "tally table"). generate_series is a great addition, because when using a table of numbers there was always a risk that you could run out of numbers. Or some joker could have deleted rows from the table. All these worries are gone with generate_series.

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

by Abhinay Malipeddi

SQLServerCentral

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.

A Poor Data Model

by Steve Jones

SQLServerCentral

Database Design and Implementation

Steve has a few thoughts on natural keys, which often turn out not to be as unique as we expect.

Improve Query Performance when SQL Server Ignores Nonclustered Index

by Additional Articles

SQLServerCentral

Performance and Tuning

Do you wonder why SQL Server ignores an index? Do you think about how you can deal with this problem? When you include too many columns in a query you decrease index selectivity. So, if you write a query like “Select * From …” the chance of choosing your nonclustered index will decrease.

What is time?

by drsql@hotmail.com

SQLServerCentral

Uncategorized

There was a post on X I read today about valuing your time. The gist was that since this person had waited 9 minutes to save $4, they valued their time at $27 an hour. I get the point being made. Time is valuable and you need to set the value of your time. It […]