what cases i can use on it sql graph ?

Question

I work on sql server 2019 . i don't know what sql graph

and what cases i can use sql graph on it

please tell me what cases i can use it sql graph

and are this good for best performance and faster query

Answer 1

i don't know what sql graph

Then start reading about it at https://learn.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-architecture?view=sql-server-ver16

and are this good for best performance and faster query

Faster compared to what?

Answer 2

SQL Graph is good, as I understand it, when you want to answer questions like "People who bought this book, also bough this and that". I think it is also good for social-media analysis.

I have played a little with the feature on my own, but I have encountered a problem where SQL Graph would fit. It's quite a niche feature, I'd say.

Answer 3

Hi @ahmed salah ,

SQL Server’s graph databases can help simplify the process of modeling data that contains complex many-to-many and hierarchical relationships. At its most basic, a graph database is a collection of nodes and edges that work together to define various types of relationships.
More details, please see:
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/sql-server-graph-databases-part-1-introduction/

Best regards
Niko

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 4

i try to read more on internet
but can't found more articles explain sql graph

You can start here: https://learn.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-overview.

Answer 5

Hi @ahmed salah ,

i try to read more on internet
but can't found more articles explain sql graph

You can also see this article:
https://iterationinsights.com/article/sql-server-graph-tables-in-power-bi/

Best regards
Niko

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".