SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

G. FritcheySQL Server 2022 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-8891-7_20

20. Graph Databases

Grant Fritchey¹  

(1)

Grafton, MA, USA

 

Introduced in SQL Server 2017, the Graph database stores nodes and edges within SQL Server, allowing you to use T-SQL to query graph data. Graph data is specifically oriented around many-to-many relationships. Graph data doesn’t lend itself to traditional relational structures but instead is focused on hierarchies and relationships past those more traditional structures. Graph data is separated from either traditional analytical data, better served by columnstore indexes, or from OLTP systems, better served ...