Consider I have a table with different columns types: CREATE TABLE [RentedHome] ( [HomeID] INT NOT NULL PRIMARY KEY CLUSTERED, [Address] CHAR (255) NOT NULL CHECK (LEN(Address) >= 2), ...

I have a performance problem with a SQL query running on SQL Server 2019 that returns the lat/long from a geography column. My query is as follows and it takes around 5 seconds to return 553 rows: SEL...