python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - sqlgeography

How to define a geography column in a table with different columns type at SQL database

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), ...
test-img

amin

sql

geography

sqlgeography

Votes: 0

Answers: 1

Latest Answer

Done! CREATE TABLE [RentedHome] ( [HomeID] INT NOT NULL PRIMARY KEY CLUSTERED, [Address] CHAR (255) NOT NULL CHECK (LEN(Address) >= 2), [Landlord] CHAR (100) NOT NULL CHECK (LEN(L...
test-img

amin

Slow performance of Latitude/Longitude conversion in query

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...
test-img

Stephen

sql

sql-server

query-optimization

sqlgeography

Votes: 0

Answers: 2

Latest Answer

NOTE: OP changed the name of the table Plans to ActivityPlans between the originally posted queries/graphical executions plans and his subsequently provided execution plan (via paste the plan) and DDL...
test-img

trenton-ftw

Posts

Questions

Blogs

Jobs