When use sql graph on sql server 2019 ?

Question

When use sql graph on sql server 2019 ?

ahmed_elbarbary.2010

Hall of Fame

Points: 3118
More actions
September 25, 2022 at 8:17 pm

#4091792

I working on sql server 2019 . i read more about sql graph
but really i don't know what befit from using sql graph
what cases that can i use sql graph on it
and what issues that sql graph solve it
so can you help me please

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

frederico_fonseca SSCoach Points: 16154 More actions · Answer 1

if you have to ask you likely don't need it - and I have to say that there is huge amount of info on the net so you asking here kind of looks you didn't bother searching for it.

some examples

https://medium.com/swlh/how-to-make-use-of-sql-server-graph-database-features-946ce38190cc

https://dgraph.io/graphdb/

and all others - https://www.google.com/search?q=graph+databases+uses

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 2

The principal use case would be extensive, many-to-many data structures. If you don't have that, you don't need to sweat it.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 3

Heh... I don't "node" for sure but I'm sure that it'll be an "edge" case. 😀 Get the "net" out... we'll all go "wandering" when it happens. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)